SUMIF conditional range

[Guest]

Is there a way to put AND in the first range,criteria of
SUMIF

normally
SUMIF(range,criteria,sumrange)
I want...
SUMIF(range1,criteria1 AND range2,criteria2, sumrange3)

I've tried a number of combinations and keep getting
errors.

 

[Dave R.]

Here you can use =SUMPRODUCT((A1:A10="Yes")*(B1:B10="Red"),C1:C10)

to sum up column C IF the corresponding row's data in A is "Yes" and B is
"Red", for example.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A100="crit1")*(B1:B100="crit2"),C1:C10)

or
=SUMPRODUCT(--(A1:A100="crit1"),--(B1:B100="crit2"),C1:C10)

 

[Dave R.]

Better make those C1:C100

Hi
try
=SUMPRODUCT((A1:A100="crit1")*(B1:B100="crit2"),C1:C10)

or
=SUMPRODUCT(--(A1:A100="crit1"),--(B1:B100="crit2"),C1:C10)

 

[Frank Kabel]

Good spot
Thanks Dave