SUMPRODUCT
 

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

SUMPRODUCT
 

Most likely one or more of the cells in Col I has text in it, and then not
numrics that have been changed to text. It must have an alpha character in

"Tufail" wrote:

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

SUMPRODUCT
 

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!
================================================== ===


"Tufail" wrote in message
...
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