SumIf - More then 1 criteria - Please assist

[Guest]

Hi,
How can i use sumif formula with more then ONE criteria?

 

[Don Guillett]

=sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22)

 

[Guest]

Use SUMPRODUCT instead.

 

[Guest]

Nope. You want sumproduct to do that. Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Biff]

=SUM(SUMIF(A1:A10,{"x","y"},B1:B10))

Biff

 

[Guest]

apperantly this does not work when the arrays include error formulas values.
can you advise

 

[Biff]

Fix the formulas so that instead of returning errors they return some other
value like a zero or a blank "".

Biff

 

[Guest]

i did so thanks
isnt there a way around?

Fix the formulas so that instead of returning errors they return some other
value like a zero or a blank "".

Biff

 

[Biff]

isnt there a way around?

Maybe. But you're better off correcting problems at their source rather than
trying to accommodate those errors downstream. They end up making things
more complicated!

Biff