Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 0 down vote favorite

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

up vote 1 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. – todofixthis 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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.