Subject: Summing one column where criteria in two other
 

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

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