ExcelBanter - Adding letters instead of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding letters instead of numbers (https://www.excelbanter.com/excel-worksheet-functions/238923-adding-letters-instead-numbers.html)

Can :)

Adding letters instead of numbers

I was curious if you could add how many "A" there were in a range.

i.e. If a1:a25 had an "A" in each cell, then how do you insert a function to
eaual 25?
--
Can :)

Pimamedic

Adding letters instead of numbers

=COUNTIF(A1:A25,"a")

Change the range as needed

"Can :)" wrote:

I was curious if you could add how many "A" there were in a range.

i.e. If a1:a25 had an "A" in each cell, then how do you insert a function to
eaual 25?
--
Can :)

Per Jessen[_2_]

Adding letters instead of numbers

Hi

If "A" is the only letter in the cell:

=CountIf(A1:A25,"A")

Regards,
Per

On 5 Aug., 00:53, Can :) wrote:
I was curious if you could add how many "A" there were in a range.

i.e. If a1:a25 had an "A" in each cell, then how do you insert a function to
eaual 25?
--
Can :)

All times are GMT +1. The time now is 01:36 AM.