SUMIF conditional range

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Hi
try
=SUMPRODUCT((A1:A100="crit1")*(B1:B100="crit2"),C1:C10)

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


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

or
=SUMPRODUCT(--(A1:A100="crit1"),--(B1:B100="crit2"),C1:C10)
Click to expand...
 
Back
Top