=COUNTA( )

[Regan]

I'm trying to find a function that will count certain text in a coulumn but exclude others.
For example....
I have a column full of letters, say a-z, but when my formula counts the letter, I want it to exclude "d". Giving me a result of 25.
Is this possible?

 

[Derek]

Hi Regan

Say your letters were in column A, put this formula in B1.

=COUNTA(A:A)-COUNTIF(A:A,"D")

hope this helps
regards
Derek

 

[Mark W.]

Or...

=COUNTIF(A:A,"<>D")

 

[Regan]

Thanks a million !