List values based on adjacent reference

[jackk]

Hi,

I would like the spreadsheet to tell me how many values have a certain value in the adjacent cell. See image below:



So in the image, I would like to make a list of all values in columns C, E, G, I & K counting how many of each have an "A" in the adjacent cell.

I hope this makes sense. It's taken me a while to get my head round this for some reason :/

[NBVC]

Since each of the A's, B's and C's have an associated cell with text to the left, then you can just count the A's, B's and C's with Countif.

e.g.

in S4:

=COUNTIF(D:L,R4)

copied down.

[Bob Phillips]

My first thought, but he says he wants a list​ of all values.

[NBVC]

I saw that too, LOL, but looking at the attachment, I see that the OP pre-entered A, B, and C and the active cell is S4, so I deduced that the OP wanted the counts of those letters

[Bob Phillips]

I saw the same, but decided (probably wrongly) that list was what he wanted and that was just too much hassle

[SamT]

I think the OP wants to look in C:K for the values in M and post the count of those with any character (A,B,C,X) adjacent in column P.
P4 = 7, P6 = 5, and P10 = 9

[NBVC]

Only one way to find out.... wait for OP to tell us