Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating cells that contain Numbers
Hi
I have 5 groups numbered 1 - 5 respectively, there are over 500 rows with each row belonging to various groups . I just want to be able to calculate, say the No. 1 group to find out how many are belonging to it. I know you could use a filter but I want the total to appear at the end of the sheet for each individual group. Example: Row 1: 5022 Joe Bloggs Position 1 Row 2: 7895 Mary J Position 5 Row 3: 5689 Sarah H Position 1 Row 4: 4589 Jane D Position 4 etc Total: Group 1 2 Staff Group 4 1 Staff Group 5 1 Staff etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating cells that contain Numbers
Assuming your group numbers are in cells D2:D5000, and that you have the
integers 1-5 in cells E2:E6 - put this formula in F2 & copy it down to F3:F6 COUNTIF($D$2:$D$5000,E2) "LittleAnn" wrote: Hi I have 5 groups numbered 1 - 5 respectively, there are over 500 rows with each row belonging to various groups . I just want to be able to calculate, say the No. 1 group to find out how many are belonging to it. I know you could use a filter but I want the total to appear at the end of the sheet for each individual group. Example: Row 1: 5022 Joe Bloggs Position 1 Row 2: 7895 Mary J Position 5 Row 3: 5689 Sarah H Position 1 Row 4: 4589 Jane D Position 4 etc Total: Group 1 2 Staff Group 4 1 Staff Group 5 1 Staff etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating a sum from cells that contain letters and numbers | Excel Discussion (Misc queries) | |||
VBA: Calculating Complex Numbers | Excel Discussion (Misc queries) | |||
re calculating numbers to times | Excel Discussion (Misc queries) | |||
Calculating two numbers in one cell | Excel Worksheet Functions | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) |