Friday, January 5, 2018

yogi_Compute The Date Subsequent To Which Cumulative Sun In Column G Is 6 or More And At Least One Cell In Column H Contains 'HLD'

Google Spreadsheet   Post  #2341

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-05-2018
Return a cell when an ongoing sum exceeds a value

The link to the spreadsheet:

I need help with a formula that will give me the most recent date when column G meets or exceeds 6. It also must check to make sure that within those dates, column H includes "HLD".

For the given data, the formula should return the date 7/12/2017.

I have tried using a query function, and an array formula, but I can't get it to work to add up to 6. Any help with this is much appreciated!

- Jesse