Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting categories
This is most likely a question which has been asked before. If so let me apologise beforehand. (If it has been asked before I cannot find it)
I have a membership database of about 950 members. There is a column headed 'Status'. This column can have 6 different entries. How can I produce the count of each category? (as a Printed report) i.e. AS = 2, SM = 628, SS = 187, LS = 123, LM = 10 I am using excel 2010 Last edited by artytac : February 7th 11 at 09:34 AM Reason: additional information |
#2
|
|||
|
|||
Quote:
Dear Artytac, Good Morning. You can use a simple COUNTIF FUNCTION. Suppose your "Status" data are at D column. Your report: _______F_________G____________ 4______AS________=COUNTIF(D2: D500,F4) 5______SM________=COUNTIF(D2: D500,F5) 6______SS________=COUNTIF(D2: D500,F6) 7______LS________=COUNTIF(D2: D500,F7) 8______LM________=COUNTIF(D2: D500,F8) Tell me if it worked for you. Feel free to ask anything about it.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
|
|||
|
|||
Dear Mazzaropi, You have pointed me in the right direction, Thank you for your prompt reply.
The report is working quite well:-) Artytac ------------------------------------------------------------------ Dear Artytac, Good Morning. You can use a simple COUNTIF FUNCTION. Suppose your "Status" data are at D column. Your report: _______F_________G____________ 4______AS________=COUNTIF(D2: D500,F4) 5______SM________=COUNTIF(D2: D500,F5) 6______SS________=COUNTIF(D2: D500,F6) 7______LS________=COUNTIF(D2: D500,F7) 8______LM________=COUNTIF(D2: D500,F8) Tell me if it worked for you. Feel free to ask anything about it.[/quote] |
#4
|
|||
|
|||
Dear Artytac,
it was a pleasure to help you. Have a nice week.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help for Counting categories in a column | Excel Worksheet Functions | |||
counting unique items within categories | Excel Worksheet Functions | |||
Counting using 2 categories | Excel Discussion (Misc queries) | |||
Counting categories | Excel Discussion (Misc queries) | |||
counting categories of text cells | Excel Discussion (Misc queries) |