Thread: CountA problem
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default CountA problem

Change the E to a D, it handles both upper and lower case.

--
Cheers,
Shane Devenshire


"ShaneDevenshire" wrote:

Hi,

Try =COUNTIF(E3:E148,"<E")

--
Cheers,
Shane Devenshire


"Jim" wrote:

I am using the formula as shown below, but I want to exclude the letter D or
d
from the count, any ideas?
Thanks
Jim

=COUNTA(E3:E148)