Can Excel do this??

M

Mark

I have Excel 2000 and I have columns of alphabetic data.
The information in each column repeats itself, i.e. there
may only appear the words "One", "Two", or "Three" in a
particular column in the spreadsheet. I have over 20,000
rows in the columns. Is there a way to have Excel give me
totals for that particular column, telling me how many
times "One" appears, how many times "Two" appears, and how
many time "Three" appears? I am really stumped on this.

Your help is apreciated in advance,

Thanks,

Mark
 
C

Corey

The only way I know is that you'll have to use a separate
formula for each. Type in the following formula with your
specified range:

=COUNTIF(A1:A20000,"One")

This should give you the number occurrences of One in that
range. Do the same for "Two" and "Three" in separate cells.
 
P

Peo Sjoblom

Try

=COUNTIF(Range,"*"&E1&"*")

where E1 holds the word you want to count.. This assumes there is one
occurrence per cell
Post back if not

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
A

Alan Beban

Array enter into a three cell row

=COUNTIF(B:B,{"One","Two","Three"})

Alan Beban
 
Top