Counting Text Entries

  • Thread starter Thread starter JackJJW
  • Start date Start date
J

JackJJW

Hi everyone,

I have a large database of information which includes columns of text
entries. Is there a way of counting these text entries? e.g.:

HBO
SL
SL
MN
RTA
HBO
SL
SL
MN
RTA
HBO
SL
SL
MN
RTA

Counting the number of HBO, RTA,SL entries etc. The database consists
of 26 worksheets, is it also possible to get the total results from all
worksheets to appear on a single summary page?

Thanks very much for any help.

Jack
 
Let's say the text values are in A1:A2000 of each sheet
In empty range (B1:B20) use =COUNTIF(A1:A2000,"HBO"),
=COUNTIF(A1:A2000,"SL"), ETC
in empty range (C1:C20) = SUM(Sheet1:Sheet20!B1), etc

Or use a Pivot Table to count the occurrences in place of COUNTIF

best wishes
 
Back
Top