Thread: SUMPRODUCT not working.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_4_] Gaurav[_4_] is offline
external usenet poster
  
Posts: 36
Default SUMPRODUCT not working.
can someone please help me understand what is wrong with the following
formula?

=SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2: $B$3515="-2"))


Reply With QuoteReply With Quote