Sum If Multiple Conditions

[Grant]

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

 

[JulieD]

Hi Grant

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

Hope this helps
Cheers
JulieD

 

[Bob Phillips]

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]

Hi Bob

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

Cheers
JulieD