Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF Problem
We collect data every 10 minutes continuously for a month at a time. When a
set trigger value is exceeded, a sample is taken. However, only one sample can be taken in a 24-hour period (beginning and ending at 2:00 pm). The information I need is . . . . how many samples would be taken in 1 month at varying trigger levels (0.75, 0.80, 0.85, etc.)? Ultimately, we would like to know what trigger level would produce 5 samples per month. The spreadsheet has the following column headers: Date Time Value Any suggestions would be greatly appreciated. If more info in needed, please let me know. Thanks!!!!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif problem | Excel Discussion (Misc queries) | |||
COUNTIF or SUMIF Problem | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
problem with countif | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions |