Change your formula to this:
=SUMPRODUCT(--(F21:F3000="U"),--(G21:G3000="Jamaica Office"),I21:I3000)
And see if you eliminate the error.
If you do get a numerical return, that shows that you *do* have 'text'
somewhere in Column I,
And that 'text' is *not* numerical text, but easily recognizable alpha text,
since the asterisk form *will* calculate all forms of numerical text.
If you *still* get the #VALUE! error, you probably have a formula in Column
I that evaluates to that error.
That's also the reason I prefer to use the asterisk form of Sumproduct.
It *warns* you of "bad" data in the calculation range.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
Hello,
I have some problam in following formula, I_col has Amount
=SUMPRODUCT((F21:F3000="U")*(G21:G3000="Jamaica Office")*I21:I3000)
this error is coming out. #VALUE!
Thanks/Tufail
