Thread: SUMPRODUCT returns !Value#
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default SUMPRODUCT returns !Value#
A formula would be quite helpful. Plus maybe some sample data :)
--
** John C **

"Dana" wrote:

I have a sumif function with two criteria so I used the sumproduct function,
but it returns the !Value# error? I can't figure out why?
Reply With QuoteReply With Quote