Sumif = and between

M

mathewheys

Hi all

I am having trouble summing the following data
A B C D E
1 1/2/05 2/5/05

10 Big 1/2/05 856
11 Small 2/5/05 1050
12 Big 2/5/05 769

Sum If A:A=Big and Between D1 and E1 should = 162
 
M

mathewheys

Hi all

I am having trouble summing the following data
A B C D E
1 1/2/05 2/5/05

10 Big 1/2/05 856
11 Small 2/5/05 1050
12 Big 2/5/05 769

Sum If A:A=Big and Between D1 and E1 should = 162
 
P

Peo Sjoblom

=SUMPRODUCT(--(A2:A10="Big"),--(B2:B10>=D1),--(B2:B10<=E1),C2:C10)

you can't use the whole range (A:A) so you need to specify the ranges
 
Top