View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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