Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count
On a worksheet i have column that contains the length of
service (in monnths ) of each of my employees. I want to a formulae that will segregate them into sertain groups e.g 0-7, and count how many of each group i have. I have tired using the countif and sum functions, but to no avail. could someone please give me some direction? lots of thanks colin |
#2
|
|||
|
|||
Take a look at =frequency() in excel's help. I think that'll do what you want.
Colin Matchett wrote: On a worksheet i have column that contains the length of service (in monnths ) of each of my employees. I want to a formulae that will segregate them into sertain groups e.g 0-7, and count how many of each group i have. I have tired using the countif and sum functions, but to no avail. could someone please give me some direction? lots of thanks colin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions |