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))
|