CountA problem

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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)
 
=COUNTA(E3:E143)-COUNTIF(E3:E143,"D")

will exclude both upper and lower case d
 
Your formula will count anything that is not "D". COUNTA was the original
formula which counts non-blanks. I assuming the OP wants to count all
non-blank cells that are NOT "E".

Either mine or Gary"s Student's suggestion should do the trick.

=SUMPRODUCT(--(E3:E148<>"d"),--(E3:E148<>""))

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

Regards,
Paul


--
 
You've been given a couple of suggestions that work, including one that uses
COUNTA. Did they not work? You may need to elaborate on what you're trying
to do.

Regards,
Paul

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counta formula 4
counta formula 3
Trailing 30 days sum calculation with excel 1
CountA question 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Help with COUNTA formula 2
Sumproduct and CountA combined? Is that possible? 1
Countif problem 2

Back
Top