Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count with condition range
Hello,
I need some help! I'm trying to count the number of times a specific pressure is not just reached, but maintained for a certain time period. I have a trend list where a measurement program has dumped data into Excel for certain points in time. For example: Column A Column B Pressure 1/1/08 11:29AM 53.50 1/1/08 3:29PM 83.76 1/1/08 7:29PM 89.54 1/2/08 11:29PM 50.12 So, what I need to be able to do is count the number of times that the pressure not just goes above 80, but stays there for at least 8 hours, let's say (so it would not count the above example, because it only stayed above 80...which I realize is not a perfect example because they're 4 hour increments and it could have theoretically stayed above 80 longer...anyway). Any ideas? Any help is appreciated--thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count cells with condition | Excel Worksheet Functions | |||
count between two date with one more condition | Excel Worksheet Functions | |||
count col-A if col-B = condition | Excel Worksheet Functions | |||
count on condition / Formula | Excel Worksheet Functions | |||
Count the occurence of more than one condition | Excel Worksheet Functions |