Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting categories of text cells
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) | |||
How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
Excel - counting cells containing a text string | Excel Worksheet Functions |