summing letters in column

[i8ig]

What formula do you need to sum up the numbers 'a' 'c' letters in a column?

 

[Scott Huish]

Do you mean there will be just a single letter in a cell, either a or c, or are you trying to count the a's and c's in words in the cell?

If it's just single letter:
=COUNTIF(A1:A100,"a")

and
=COUNTIF(A1:A100,"c")

 

[ADAMC]

Do you mean you want to count how many times the letters A and C appear in a column? IF so do you want just A or just C or a combined total of both!?

 

[ExcelChampion]

If you want to count either/or then:

=SUM(COUNTIF(A:A,{"A","C"}))

If you want to count separately, then use Hotpepper's suggestion.

 

[i8ig]

Thanks, both will work