Thread: Subject: Summing one column where criteria in two other
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Subject: Summing one column where criteria in two other
No need for wildcards

=SUMPRODUCT(--(A2:A20="heather"),--(ISNUMBER(MATCH(B2:B20,{"b";"eb"},0))))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rob" wrote in message
...
What if I want to qualify it more with where one column looks for heather
and
the other looks for b or eb. Can I use a wildcard * in sum product


Reply With QuoteReply With Quote