counting categories of text cells

B

Brownjc96

I have four different categories that can be entered into a specific column,
I would like to keep a running tally of each categorie. So as I add a new
row of information, I fill in that column information, let's say I'm asking
if person is right handed or left handed. I would like a tally of the number
of lefties and righties on a separate tabbed sheet. Can anyone assist? JB
 
N

Naz

You could use this formula

=COUNTIF($A$1:$A$10,"left")

and it will count the number of occurances of lefties.
of course instead of "left" in the formula you could reference a cell in a a
table.

Alternatively you could explore PivotTables
 
Top