counting categories of text cells

[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

[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

--

_______________________
Naz,
London


"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]

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

[Brownjc]

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
>