sumif with multiple criteria

[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.

[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

"benb" wrote:

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

[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.

"Peo Sjoblom" wrote:

> 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
>
> "benb" wrote:
>
> > 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.

[benb]

Nevermind, I got it. Thanks.

"Peo Sjoblom" wrote:

> 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
>
> "benb" wrote:
>
> > 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.