N
Nir
Hi,
How can i use sumif formula with more then ONE criteria?
How can i use sumif formula with more then ONE criteria?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
=sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22)
D
Dave F
Use SUMPRODUCT instead.
J
Jim Thomlinson
Nope. You want sumproduct to do that. Check out this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
B
Biff
=SUM(SUMIF(A1:A10,{"x","y"},B1:B10))
Biff
Biff
N
Nir
apperantly this does not work when the arrays include error formulas values.
can you advise
can you advise
B
Biff
Fix the formulas so that instead of returning errors they return some other
value like a zero or a blank "".
Biff
value like a zero or a blank "".
Biff
N
Nir
i did so thanks
isnt there a way around?
isnt there a way around?
Biff said:Fix the formulas so that instead of returning errors they return some other
value like a zero or a blank "".
Biff
B
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
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