counting values in a range

[pyclen]

Hi Everybody,

this may have been answered somewhere previously however I did not find a solution.

I am trying to count characters in a range of cells (yea, sounds easy (and I am sure for some here it is)) however I can't figure it out
I am using Excel365 (work/home) and have the following table, and I need to count the number of times there is a C and an M in any given column.
The countif/count function works only if there is a single letter in the cells of the whole column, but when there is a combo of C and M (whether C, M or CM, no matter) it falls apart.

I also used the len/substitute formulas, as well as count(search({"C"} in that range. When I use either of these functions on any column other than the first (column D), I get a spill error.

Any help solving this issue is greatly appreciated

Book1
	C	D	E	F	G	H	I	J
4	Condition	Initital	T1	T2	T3	T4	T5	T6
5	Condition 1	C, M	C	C	C, M
6	Condition 2
7	Condition 3		C	C		C	C, M	C, M
8	Condition 4
9	Condition 5
10	Condition 6
11	Number of C's	0	2	2	0	1	0	0
12	Number of M's	0	0	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
D11:J11	D11	=COUNTIF(D5:D10,"C")
D12:J12	D12	=COUNTIF(D5:D10,"m")

 

[Joe4]

You can use wildcards, i.e.

=COUNTIF(D5:D10,"*C*")

and

=COUNTIF(D5:D10,"*M*")

 

[pyclen]

thanks so much, appreciate it (and as I said, for sure easy for someone around here )

 

[Joe4]

You are welcome.
Glad I was able to help!