countif/counta

hallhv01 · May 8th, 2002, 09:44 AM

I am trying to count the number of responses in a data range, they are as follows S-J, S-T, S-E. What function can I use to count how many of each I have? I tried counta(datarange,"S-J") but it comes up wrong.

Aladin Akyurek · May 8th, 2002, 09:48 AM

Quote:

On 2002-05-08 08:44, hallhv01 wrote:
I am trying to count the number of responses in a data range, they are as follows S-J, S-T, S-E. What function can I use to count how many of each I have? I tried counta(datarange,"S-J") but it comes up wrong.

=COUNTIF(datarange,"S-J")

Follow the same logic for the other responses.

Nimrod · May 8th, 2002, 09:54 AM

The way I'm reading your problem is that you have a DataRange (i.e. column) that has three Vales in it S-J ,S-T, S-E.

If this is the case then the following formula will work.=COUNTIF(A:A,"S-E")
This formula assumes the column with the values is Column A. You would need to put this in 3 cells and modify The value you looking for i.e. S-J etc

May 8th, 2002, 09:54 AM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	The way I'm reading your problem is that you have a DataRange (i.e. column) that has three Vales in it S-J ,S-T, S-E. If this is the case then the following formula will work.=COUNTIF(A:A,"S-E") This formula assumes the column with the values is Column A. You would need to put this in 3 cells and modify The value you looking for i.e. S-J etc __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

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

May 8th, 2002, 09:44 AM	#1
hallhv01 New Member Join Date: May 2002 Posts: 25	I am trying to count the number of responses in a data range, they are as follows S-J, S-T, S-E. What function can I use to count how many of each I have? I tried counta(datarange,"S-J") but it comes up wrong.