Excel Formula Errors

[Griffey5]

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.

 

[David Biddulph]

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 ?

 

[Don Guillett]

Pray tell, which is the third condition?

 

[Griffey5]

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

 

[Griffey5]

I tried using the last condition only and it does nothing. So the problem is
in the last condition. I don't see what the problem could be.

 

[Griffey5]

Don:

Last condition is : ('Batch Log'!H2:H2001="3000272.02"),

 

[Don Guillett]

try
=3000272.02
instead

 

[Ragdyer]

It's already been suggested in the other thread in the functions group.

To the Griffey5 ... Do you see how this multi-posting of yours wastes
peoples time and efforts, duplicating suggestions already made?

 

[Griffey5]

Didn't work this way either. I changed the format to make it a number
instead of text and took off the "" still not working.

 

[Gord Dibben]

Just changing the format does mean you changed text to a number.
Format to General then re-enter 3000272.02


Gord Dibben MS Excel MVP