counting categories of text cells

[Guest]

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

 

[Guest]

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

 

[Dave Peterson]

Take a look at the =countif() function.

=countif(Sheet1!B:B,"L")

Will count the number of cells that contain L in column B of sheet2.

Debra Dalgleish has some nice instuctions for counting at:
http://www.contextures.com/xlFunctions04.html
In particular:
http://www.contextures.com/xlFunctions04.html#CountIf

 

[Guest]

Home Run, thanks Dave!!! JB

Take a look at the =countif() function.

=countif(Sheet1!B:B,"L")

Will count the number of cells that contain L in column B of sheet2.

Debra Dalgleish has some nice instuctions for counting at:
http://www.contextures.com/xlFunctions04.html
In particular:
http://www.contextures.com/xlFunctions04.html#CountIf