Excel Formula Error
Tried removing the parenthesis and it did not work as a number. Also tried
changing it to text so it would read it as text, did not work. I even tried
changing the number to 3000272-02 so it would read as text, did not work.
Yes I know this is an array.
"Ragdyer" wrote:
Perhaps the values in Column H are true XL numbers, and *not* text!
Your parenthesis placed around "3000272.02" are telling the formula to look
for *text* values.
It they're numbers, just remove the parens.
And of course, you *do know* that your formula is an *array* formula, and
must be entered using CSE.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Griffey5" wrote in message
...
What is wrong with this formula?
=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch
Log'!F2:F2001,0))
It will compute successfully with just the first two conditions, but
cannot
when the third condition is added.
|