| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count consecutive absences with a limit
I have an attendance roster for the month and want to count the number of
absences. The problem I am having is that I can only count 5 consecutive absences at one time. They can have 7 consecutive absences for one period and then another set of absences for 5 days. That totals to 10 allowed absences and 2 unallowed absences. How would you run a function to do this calculation automatically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| limit and count radio button | Excel Discussion (Misc queries) | |||
| Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
| Count Consecutive Cells | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Threaded Mode
