Thread: COUNTIF Problem
View Single Post
  #1   Report Post  
Eaglered
 
Posts: n/a
Default 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!!!!!!!!