sumproduct exclude count

D

Dreamstar_1961

I'm trying to get somproduct to count every occurance of a word but except
where they match another word. like below it would not count both "problem"
and "solved" but would count every thing else, but it don't seem to be
working, this is how I thought it be written
=sumproduct((a7:a60="test")-(b7:b60={"problem","solved"}))
given a result for below of 3, but that is not working as I seem to have a
ghost of 1 coming up,
a7 test b7problem
a8 test b8 solved
a9 test
a10 test b10 resloved
a11 test b11 next
 
T

Toppers

TRY:

=SUMPRODUCT(--(A7:A60="test"))-SUMPRODUCT(--(A7:A60="test")*(B7:B60={"Problem","Solved"}))
 

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

Top