Thread: Return text using Sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deeds Deeds is offline
external usenet poster
  
Posts: 113
Default Return text using Sumproduct
Looking to return text using sumproduct:

=SUMPRODUCT((C5:C9=A1)*(D5:D9=A2)*(E5:E9))

where E5:E9 contains text which I want to return.

How do I use sumproduct to return text? It keeps giving me #Value!

Thanks
Reply With QuoteReply With Quote