View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default 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 :)