=COUNTA( )

Regan · Mar 14th, 2002, 07:03 AM

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 · Mar 14th, 2002, 07:17 AM

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. · Mar 14th, 2002, 07:58 AM

Or...

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

Regan · Mar 14th, 2002, 09:39 AM

Thanks a million !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 07:03 AM	#1
Regan New Member Join Date: Mar 2002 Posts: 2	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?

Mar 14th, 2002, 07:17 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Mar 14th, 2002, 07:58 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Or... =COUNTIF(A:A,"<>D")

Mar 14th, 2002, 09:39 AM	#4
Regan New Member Join Date: Mar 2002 Posts: 2	Thanks a million !