Adding cells with alphabet and returning a numbric value
 

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

=countif(range,"c")

"Irv" wrote in message
...
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

=COUNTIF(Range,"C")

would count C-entries.

"Irv" wrote in message
...
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

You are trying to count the number of cells that contain 'C'?
If your range is A1:A10
=COUNTIF(A1:A10,"C")

tj


"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

=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