Thread
:
Excel Formula Errors
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett