Countif within a Countif - Countception

**stiganovski** · 04-26-2012, 12:23 AM

Luckily we don't need to go deeper...

Here is what I am trying to achieve.
\1

I have been using the CountIf formula to produce counts for column C.
Now what I am trying to get is a count of the data in C and then D.
So I want excel to count the number of "Global Village positive feedback", then a separate count for "Global Village negative feedback", etc
Then a count for "Other positive feedback" etc etc

Once I have these I can graphically take care of the rest.

Any ideas?

Cheers all

**dilipandey** · 04-26-2012, 12:38 AM

Hi Stiganovski,

You can use CountIFs function here.. something like :-

=COUNTIFS($C$2:$C$16,"Global Village",$D$2:$D$16,"positive feedback")

Above is for Positive Feedback.... similarly you can revise the formula for Negative feedback and others.

you may need to adjust reference / ranges in the formula. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>