Thread: Sumproduct to ignore text and ""
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ricky Pang
 
Posts: n/a
Default Sumproduct to ignore text and ""
Hello Experts,
How would you modify this formula so that the text and ="" [blanks] in the
range of B1:B8 are ignored; thus, not producing a #Value! error?

=SUMPRODUCT((A1:A8="a")*(B1:B8))

Thanks in advance,
Ricky


Reply With QuoteReply With Quote