Help with Excel Formula

  • Thread starter Thread starter Griffey5
  • Start date Start date
G

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.
 
Hi,

Probably the last part should read ")*('Batch Log'!F2:F2001=0))

You appear to be mixing ideas that apply for SUMPRODUCT and SUM arrays.
 
Wouldn't this return a value of "0" instead of adding the column if all three
conditions were met?
 
Hi,

I wasn't sure what you were trying to do with the last part of the formula.
If what you want to do is add any items in column F that meet the first three
criteria, then the formula should end ")*('Batch Log'!F2:F2001))

If the first all of the first 3 conditions aren't met than the result of the
first three products will be 0 and 0 time entries in column F will produce 0.
 
Back
Top