Subject: Summing one column where criteria in two other

R

Rob

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
 
B

Bob Phillips

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)
 
Top