SumIf - More then 1 criteria - Please assist
 

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

SumIf - More then 1 criteria - Please assist
 

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

--
Don Guillett
SalesAid Software

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?

SumIf - More then 1 criteria - Please assist
 

Use SUMPRODUCT instead.
--
Brevity is the soul of wit.


"Nir" wrote:

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

SumIf - More then 1 criteria - Please assist
 

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

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

Jim Thomlinson


"Nir" wrote:

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

SumIf - More then 1 criteria - Please assist
 

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

Biff

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?

SumIf - More then 1 criteria - Please assist
 

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

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?

SumIf - More then 1 criteria - Please assist
 

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

Biff

"Nir" wrote in message
...
apperantly this does not work when the arrays include error formulas
values.
can you advise

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?

SumIf - More then 1 criteria - Please assist
 

i did so thanks
isnt there a way around?

"Biff" wrote:

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

Biff

"Nir" wrote in message
...
apperantly this does not work when the arrays include error formulas
values.
can you advise

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?

SumIf - More then 1 criteria - Please assist
 

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

"Nir" wrote in message
...
i did so thanks
isnt there a way around?

"Biff" wrote:

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

Biff

"Nir" wrote in message
...
apperantly this does not work when the arrays include error formulas
values.
can you advise

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?