View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Excel Formula Errors

Pray tell, which is the third condition?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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