Sum If Multiple Conditions
 

Hi Bob

thanks for the correction - don't know what happened there it was a straight
copy / paste from excel !

Cheers
JulieD

"Bob Phillips" wrote in message
...
I think Julie means 2005 not 1905

=SUMPRODUCT(--(F2:F784=DATE(2005,1,10)),--(B2:B784=100),E2:E784)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JulieD" wrote in message
...
Hi Grant

try
=SUMPRODUCT(--(F2:F784=DATE(5,1,10)),--(B2:B784=100),(E2:E784))

Hope this helps
Cheers
JulieD

"Grant" wrote in message
...
I need help with my formula. I am trying sum data based on multiple
conditions. I used SUMPRODUCT in the past to do this. Column F needs to
greater than 1/10/2005 and column B needs to equal 100. If these
conditions
sum column E. Can this be done?

T.I.A.
Grant

SUMPRODUCT((F2:F784,"="&DATE(2005,1,11)*(B2:B784= 100)*('E2:E784))