Adding cells with alphabet and returning a numbric value

I

Irv

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
 
T

tjtjjtjt

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

tj
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Returning 1 of 4 values if conditions are met 4
Would like to input 3 letters into a cell, each having a different numerical value 5
Sumif apllying to all sheets in workbook 2
COUNTIFS ? 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding location (or start cell) of highest consecutive values 3

Top