Not a problem Bernard, but it is one of those cases where -- will not work,
but * does (don't mention this to RagDyer)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bernard Liengme" wrote in message
...
The two ranges are not the same size
E103:P114 is 12 by 12 while E98 by P98 is 12 by 1
Tell us more about the project's data layout
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
Formula is: =SUMPRODUCT((E103:P114)*(E98:P98="Project"))

Should return 0. But I also get the error if there are values greater
than
zero in the range which meet the criteria.

Thanks, Dave
--
Brevity is the soul of wit.