why does this formula return a #VALUE! error
Non-numeric, yes. Blanks, to be specific. See my responses to Bob and
Bernard. Thanks for the help.
Dave
--
Brevity is the soul of wit.
"Dave Peterson" wrote:
Any errors in any of those cells?
And non-numeric data in the first range?
Dave F wrote:
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.
--
Dave Peterson
|