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

question by: Aerodream

https://productforums.google.com/forum/#!topic/docs/2-WR1SkayE0;context-place=mydiscussions

Return a cell when an ongoing sum exceeds a value

The link to the spreadsheet:

https://docs.google.com/spreadsheets/d/1Y29p5AmM5pSI2iNN-7_StueglWngfnd-hOFA8-cOz6U/edit#gid=0

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