Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I put the following as a formula:
1. 1 hour or greater to count as "1" 2. or a cumulative total of 2 hours (or more) in any seven consecutive days to count as "1" 3. If the 1 hour and the 2 hours are exceeded within a consecutive seven day period should count as "2" The table is set out as follows: cols: A= Date B= Hours Cells: "P5"= a consecutive 7 day period ("G5" and "H5"= dates for a rolling last 7 days). I have tried 'COUNT' but having trouble with it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNT IF - 2 conditions | Excel Discussion (Misc queries) | |||
Count if - 2 conditions | Excel Discussion (Misc queries) | |||
How to count after 2 conditions are met | Excel Worksheet Functions | |||
Count ifs - 2 conditions | Excel Discussion (Misc queries) | |||
Count with 2 conditions? | Excel Worksheet Functions |