Subject: Summing one column where criteria in two other

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum with three criteria 4
SUMIFS, one criteria range, multiple criteria 3
Sum Values from different column 1
Loop or Find code ?? need help !! 4
Sumproduct Formula to counts multiple criteria in two columns? 1
Summing one column where criteria in two other columns are met 5
Calculate % Length of one Criteria against % Length of other 4 Cri 2
sumifs criteria 3

Top