Counting the number of unique entries in a row! Help me!

Jon15n · May 24th, 2002, 06:15 PM

Hi, I am trying to put the total number of cells that contain the word "CON" in them into just a total cell, corresponding from a row of cells.
So, it would be basically one row, and I would need at the end of it, a box that would be the total, and it would say like "1" or "2". The thing is, I HAVE to put the word "CON" into some of the cells, and I just need to count the number that contain the word "CON". HEY ALSO, If there are NO cells with the word "CON" in them within a row, how can I make it so that the total cell is just blank?!?!?
Thanks!

[ This Message was edited by: Jon15n on 2002-05-24 17:38 ]

Tom Schreiner · May 24th, 2002, 06:22 PM

Hi
Rookie with formulas here, but it seems that CountIf should do what you like...
If your list is in Range A1 to A10, your total in A12.
Place this formula in A12.

=COUNTIF(A1:A10,"CON")

Tom

Luke van der Steen · May 24th, 2002, 06:33 PM

Hi

The answer, as I understand it, is very easy

Use the formula 'countif' in the totals cel.

For example countif(a1:a200;"con")

Hope it helps

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

May 24th, 2002, 06:15 PM	#1
Jon15n New Member Join Date: May 2002 Posts: 5	Hi, I am trying to put the total number of cells that contain the word "CON" in them into just a total cell, corresponding from a row of cells. So, it would be basically one row, and I would need at the end of it, a box that would be the total, and it would say like "1" or "2". The thing is, I HAVE to put the word "CON" into some of the cells, and I just need to count the number that contain the word "CON". HEY ALSO, If there are NO cells with the word "CON" in them within a row, how can I make it so that the total cell is just blank?!?!? Thanks! [ This Message was edited by: Jon15n on 2002-05-24 17:38 ]

May 24th, 2002, 06:22 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Rookie with formulas here, but it seems that CountIf should do what you like... If your list is in Range A1 to A10, your total in A12. Place this formula in A12. =COUNTIF(A1:A10,"CON") Tom

May 24th, 2002, 06:33 PM	#3
Luke van der Steen New Member Join Date: May 2002 Location: Netherlands Posts: 6	Hi The answer, as I understand it, is very easy Use the formula 'countif' in the totals cel. For example countif(a1:a200;"con") Hope it helps