Sum (multiple) If

[blues_sender]

Hi,
I have a small problem, and if you can help it would be great

suppose that I have 4 columns, A B C and D. (from 1 to 1000)
Now, I want E[1] (Column E, row 1) to hold the sum of D11000
but only to sum the rows (filter it) where A = 1 AND (b=1 or b=2) AN
c=2.
(And I want to be able to drug E down, i.e be able to do so for ever
E)

=SUMIF(A1:A1000,1,D11000) - Does the trick for the A column, but
want to be able to insert the conditions for B and C as well.
(i.e A = 1 AND (b=1 or b=2) AND c=2.)

any ideas?
thanks a lo

 

[Fank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000=1)*(B1:B1000={1.2})*(C1:C1000=2)*
(D11000))

 

[Jim May]

In E1 enter:

=SUMPRODUCT((A1:A1000=1)*(OR(B1:B1000=1,B1:B1000=2))*(C1:C1000=2)*(D11000)
)

Not sure why you want to drag down off hand, but anyway hope the above
helps..