Counting letters

[samtwilliams]

Hi All,

Im trying to think of a way to count values in a column, my values consist of things like
A1 C1, Z6, Z8, BB2, J6 and many others.

Is there a way to count how many Z6's, C1's etc.?

Anyone help?

[plitfyg]

Hi All,

Im trying to think of a way to count values in a column, my values consist of things like
A1 C1, Z6, Z8, BB2, J6 and many others.

Is there a way to count how many Z6's, C1's etc.?

Anyone help?

You could use countif function for example.

=COUNTIF(B5:B13;"c1")

Where B5:B13 is your colums (range with values you want to count), "c1" is the value to count ("c1", "z6", "bb2" etc)

Plitfyg

[samtwilliams]

Thanks that works great! but i have encountered a new problem.

I have a column with the values which is great but the cell to the right I specify a qty of say A1, C1 etc. Is there a way this count can work that out.
20 xA1
1 x A1
15 x A1
1 x C1
3 x c4

and count them?

[Paul]

So in your example, would your expected result be 36 A1's, 1 C1 and 3 C4's?

If so, try:

=SUMIF(B5:B13,"A1",A5:A13)

Where B5:B13 represents the search range, "A1" is what you're searching for, and A5:A13 represents your sum range.

[samtwilliams]

That works perfectly,

Thanks Paul
Your a credit to this forum.

Thanks
Sam