LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count cells with condition Amanda Excel Worksheet Functions 2 October 13th 07 06:59 PM
count between two date with one more condition count between two date with one more con Excel Worksheet Functions 1 April 19th 07 04:22 AM
count col-A if col-B = condition Balhar Excel Worksheet Functions 8 January 18th 06 09:52 PM
count on condition / Formula SAM ONG Excel Worksheet Functions 1 November 18th 05 10:56 AM
Count the occurence of more than one condition wutang1105 Excel Worksheet Functions 1 August 26th 05 07:21 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"