counting a text value in excel

[angrymissy]

I have a spreadsheet in excel and one column is a text entry that represents a product (CG8, E3, etc. example). I have a 50,000 line spreadsheet where I need to count how many prroducts are in that one column (so it would tell me that CG8 appeared 10,000 times in that column, E3 appears 5,000 times, etc). Anyone know a quick way to do this?

<BR><img src="http://thereisnogod.faithweb.com/images/missy2.gif" width="300" height="100" border="1">

[jeffdwright2001]

Go to Excel help and look up "CountIf". It will give you the expression example. It tells you how many times a specific entry occurs within a requested range.

http://img78.photobucket.com/albums/v297/jeffdwright2001/Twain_quote.jpg

[angrymissy]

execellent, thank you... i knew there was a way to do it i just dont have time to figure out what the function was

<BR><img src="http://thereisnogod.faithweb.com/images/missy2.gif" width="300" height="100" border="1">

[Reephdweller]

I would love it if there was an Excel forum on this board where all the various Excel help threads could reside. They really great for reference when in a jam.

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[JPMNICK]

I think we should have a computer section of the board. There seems to be a lot of questions on here regarding this topic.

http://home.comcast.net/~nickcontardo/jpm_sig.jpg
Thanks to Monsterone for my first sig.