I entered it as an array and column H is entered as text
I have not tried it with just the last condition.

"David Biddulph" wrote:

Three questions:
Did you enter it as an array formula (Control Shift Enter) ?
Are you sure that your column H data are text strings (as you've put the
="3000272.02" condition in quotes) ?
Did you try it with just the 3rd condition, removing the 1st and 2nd ?
--
David Biddulph

"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.