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?