Thread: why does this formula return a #VALUE! error
View Single Post
  #1   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
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.
Reply With QuoteReply With Quote