Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any (6) consecutive entries
I have a table that shows number of hours worked each month in columns (a
single row for each employee). I want my table to alert me when the sum of any six consecutive months equals 400. I wanted to use conditional formatting, but can't figure out how to write the formula to look at the sum of "any six consecutive entries" - KKD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to align some entries in consecutive rows like Word tabs | Excel Discussion (Misc queries) | |||
Identifying Consecutive Entries | Excel Discussion (Misc queries) | |||
Prevent Consecutive Entries | Excel Worksheet Functions | |||
Adding Consecutive Entries | Excel Discussion (Misc queries) | |||
Adding Consecutive Entries | Excel Discussion (Misc queries) |