sumif with multiple criteria

B

benb

The subject pretty much sums up my question (no pun intended). I want to use
SUMIF(), but I have more than one criteria. An imbedded AND() won't work.
Any other suggestions? Thanks in advance for your help.
 
P

Peo Sjoblom

Try

=SUMPRODUCT(--(Range1=condition1),--(Range2=condition2),sumrange)

you can of course use multiple criteira on the same range so in that case
replace Range2 with Range1

Regards,

Peo Sjoblom
 
B

benb

Thanks for your reply. I was afraid SUMPRODUCT would be the answer. I'm not
very knowledgable in that function and MS Help is no use. I've tried
recreating your example, but I'm not getting something write because I am
getting an error message (#NUM!). The function I used was
=SUMPRODUCT((T:T="00"),(R:R>0),(Q:Q="Y"),R:R). It couldn't be because I am
using three criteria? The error message implies that the function requires a
numeric argument where I am using something else.
 
B

benb

Nevermind, I got it. Thanks.

Peo Sjoblom said:
Try

=SUMPRODUCT(--(Range1=condition1),--(Range2=condition2),sumrange)

you can of course use multiple criteira on the same range so in that case
replace Range2 with Range1

Regards,

Peo Sjoblom
Click to expand...
 
Top