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!
Click to expand...

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