Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have a spreadsheet I'm working on that we use to run large corporate events. Each segment length has a length as well as corresponding start time. I want each cell in the time column to look above itself and find the previous time and then add it to that segments length.

In column A it has the start time of that segment. Then, in column B, it has the segment length. So for example, A1: start time & B1: segment length. I then want B2 or C2 or D2 (whichever is next) to go up and look for A1 and add it to B1.

The problem is that there are often blank rows in between so even though they are blank, it returns an error with the offset function statically moving 1 row at a time.

I can provide a screen shot if that helps. But, in short, I'm trying to dynamically find the cell above a given cell with content in it knowing that there could be may blank rows in between and not wanting them to calculate.

share|improve this question
Hi Conway, welcome to Web Applications !! The segment length is then also time based, like A1 = 12:00:00, B1 = 00:35:00 and E1 = 02:25:00. The total time would be Z1 = 15:00:00? A screenshot often tells more, then words can describe !! –  Jacob Jan Tuinstra Oct 3 '13 at 6:31
And even better than a screenshot, is a link to the spreadsheet in question (if you're able to share it). –  Vidar S. Ramdal Oct 9 '13 at 14:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.