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 am developing a "Daily Personal Inventory" spreadsheet based off a related Lifehacker article.

I've successfully made a few modifications based on my own circumstances/goals, but there is one particular change that I am having trouble with.

I would like my scores to reflect only the most recent 30 entries (i.e., the last 30 form responses).

How can I reference a cell range relative to the bottom of the sheet rather than the top?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Not familiar exactly with the way this particular sheet works but I would try using a =sumif and passing the timestamp. See here.

share|improve this answer
    
Oh, that actually might be more useful than the approach I was thinking of, as I could then explicitly select all values from the last month rather than kludging it by trying to select the last 30 rows. –  user22405 Jul 21 '12 at 2:35
2  
If you use the "=large(F:F,30)" where F is the column with your timestamps, that will tell you the 30th largest value, then just sum everything with a timestamp greater than that. –  mhoran_psprep Jul 21 '12 at 4:02

Your Answer

 
discard

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