=COUNTIF(Range,"C")

if there can be are more than one C i the cells


=SUMPRODUCT(LEN(Range)-(LEN(SUBSTITUTE(UPPER(Range),"C",""))))

both formulas will count c and C, if you want C only

=SUMPRODUCT(LEN(Range)-(LEN(SUBSTITUTE(Range,"C",""))))

Regards,

Peo Sjoblom

"Irv" wrote:

Is it possible to write a formula to get a numeric value when trying to add
up the number of a specific letter (i.e. #of C's) in a range' of cells. If so
how do I write the formula.

Ex: =IFsum(???) or =IF(range, 'C')???

Help