How to countif involving another column?

G

Gregg

I'm drawing a blank on how to do this. I need a formula to count "Yes"
values per unique value in another colum. (see example)

The first column (A) shows trip codes.
The second column (B) shows "Yes" or blank.

I need a formula that counts all "Yes" values in column B per trip
code.

For example, using the data below, "2" would be the answer because 2
trip codes corresponded to "Yes".

Trip Covered
tr-24 Yes
tr-24 Yes
tr-24 Yes
tr-50
tr-50
tr-16 Yes
tr-16 Yes
tr-16 Yes
tr-16 Yes

It might help to know if "Yes" appears next to a particular trip code,
it appears next to each of that code.

Excel 2002

Thanks for your help!
 
M

mcg

Gregg said:
I'm drawing a blank on how to do this. I need a formula to count "Yes"
values per unique value in another colum. (see example)

The first column (A) shows trip codes.
The second column (B) shows "Yes" or blank.

I need a formula that counts all "Yes" values in column B per trip
code.

For example, using the data below, "2" would be the answer because 2
trip codes corresponded to "Yes".

Trip Covered
tr-24 Yes
tr-24 Yes
tr-24 Yes
tr-50
tr-50
tr-16 Yes
tr-16 Yes
tr-16 Yes
tr-16 Yes

It might help to know if "Yes" appears next to a particular trip code,
it appears next to each of that code.

Excel 2002

Thanks for your help!

create pivot table - a bit way round but gives you infornation you need
mcg
 

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