+ Reply to Thread
Results 1 to 5 of 5

Hard to explain, please help

Hybrid View

FooFighter616 Hard to explain, please help 06-13-2012, 11:53 AM
romperstomper Re: Hard to explain, please... 06-13-2012, 12:09 PM
oeldere Re: Hard to explain, please... 06-13-2012, 12:09 PM
Cutter Re: Hard to explain, please... 06-13-2012, 01:26 PM
arlu1201 Re: Hard to explain, please... 06-13-2012, 02:20 PM
  1. #1
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Hard to explain, please help

    Because you have sorted your data by column B here is an alternative to SUMPRODUCT()

    =COUNTIF(INDEX($A$2:$A$8761,MATCH(1,$B$2:$B$8761,0)):INDEX($A$2:$A$8761,MATCH(1,$B$2:$B$8761,0)+COUNTIF($B$2:$B$8761,1)-1),">=600")

    Change the 1's in the formula to cell ref holding the hour ending value so that by changing the value in that cell the formula will recalc for the new value
    Last edited by Cutter; 06-13-2012 at 01:32 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1