IF/COUNTIF

T

Teri

I'm not sure if this is a VLOOKUP or IF/COUNTIF. How can I count the number
of occurrences of a value in column D that match column E and will put the
values in the table as shown below? Any help would be deeply appreciated!

No Response Very Dissatisfied
< 6 months
6 mos - 1 yr
1-2 yrs
3-5 yrs
5+ yrs
Not Indicated
 
J

JS2004R6

Hi Teri,

You can use a COUNTIF like below. Note: I added a formula to the Column F
cells (=D1 & " " & E1). Copy that formula down as far as there are entries in
Columns D/E.

Hope it helps.

Regards,
James

* Match items in Column A, No Response is Column B, Very Dissatisfied is
Column C.

No Response Very Dissatisfied
Less than 6 mos =COUNTIF(F:F,(A2 & " " & $B$1)) =COUNTIF(F:F,(A2&" "&$C$1))
6 mos - 1 yr =COUNTIF(F:F,(A3 & " " & $B$1)) =COUNTIF(F:F,(A3&" "&$C$1))
1-2 yrs 1 =COUNTIF(F:F,(A4 & " " & $B$1)) =COUNTIF(F:F,(A4&" "&$C$1))
 
B

Barb Reinhardt

Can you be more specific on what you have in column D and E? Your question
doesn't provide enough information.
 

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