Thread: CountA problem
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default CountA problem

=COUNTA(E3:E143)-COUNTIF(E3:E143,"D")

will exclude both upper and lower case d
--
Gary''s Student - gsnu200765


"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)