why does this formula return a #VALUE! error
I can't reproduce the problem.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"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.
|