If column W contains department names and B4 contains dept name you are
querying then

=SUMPRODUCT(--(raw_data!$E$2:$E$8002="good"),--(raw_data!$W$2:$W$8002=B4))

=SUMPRODUCT(--(raw_data!$E$2:$E$8002="very
good"),--(raw_data!$W$2:$W$8002=B4))

etc.

Regards,
Stefi

€žDJ€� ezt Ã*rta:

Thanks but didn't work - here is formula I have -
=SUMPRODUCT(--(ISNUMBER(SEARCH("good",raw_data!$E$2:$E$8002))*(--(ISNUMBER(SEARCH(B4,LEFT(raw_data!$W$2:$W$8002,2)) ))))).

What I am trying to do is match how many people said GOOD (for example) from
a particular division column W. If I put in countif it messes it up...

--
DJ


"Jacob Skaria" wrote:

Without seeing the data it would be difficult to suggest but will the below
work?

=COUNTIF(A:A,"*good*")-COUNTIF(A:A,"*not*")

OR
'count all responses minus count entries having not, bad etc;
=COUNTA(A:A)-COUNTIF(A:A,"*not*")

If this post helps click Yes
---------------
Jacob Skaria


"DJ" wrote:

Got huge list of responses to survey - they a very good, good, not good,
not good at all. Problem I have is that when I try to count how many instance
of say good there are sheet counts all that have good i.e. very good, not
very good etc - can anyone help me?
--
DJ