Thread: SUMPRODUCT
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alonso[_2_] Alonso[_2_] is offline
external usenet poster
  
Posts: 58
Default SUMPRODUCT
Well
now instead of a #VALUE!
i get a zero 0

again
it seems that the error is somewhere the last calculation




"JMB" wrote:

you should not need the isnumber
=SUMPRODUCT((ref!CX2:CX1069=prog!J5)*(ref!CY2:CY10 69=prog!K5)*(ref!DA2:DA1069=prog!M5),ref!DB2:DB106 9)


Reply With QuoteReply With Quote