On Jan 6, 9:34*am, Griffey5
wrote:
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.

Look at the format of H2:H2001. Is truly text? I can only guess that
perhaps that 3rd term should have 3000272.02 instead of "3000272.02".
Alternatively, perhaps you intended H2:H2001 to be formatted as text,
but it is not.

Having said that, I should add that I think it is a bad idea to test
for equality of a non-integral value (unless it is text). Even if you
form 3000272.02 from integers (e.g. 1000*A1+mod(A2,1000)+mod(A3,100)/
100), it is not exactly what it appears to be.

Finally, if my guesses prove to be incorrect, it would be prudent for
you to explain what you mean when you say the formula "cannot
compute". Do you get an Excel error, as your subject line suggests?
If so, what error? Or do you simply get an unexpected result, as the
phrases "cannot compute" suggests to me? If so, what do you get, and
what do you expect instead?

HTH.