Home Run, thanks Dave!!! JB

"Dave Peterson" wrote:

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

Brownjc96 wrote:

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

--

Dave Peterson