Ask Your Question

O's profile - activity

2017-03-17 20:55:39 +0200 received badge  Taxonomist
2013-08-26 12:23:38 +0200 received badge  Famous Question (source)
2013-08-26 12:23:38 +0200 received badge  Notable Question (source)
2013-04-10 17:33:03 +0200 received badge  Popular Question (source)
2012-12-12 18:17:33 +0200 answered a question Average of last x rows in Calc?

Belated thanks for your very useful answer.

2012-12-12 18:16:46 +0200 received badge  Scholar (source)
2012-12-03 09:55:59 +0200 asked a question Average of last x rows in Calc?

In a spreadsheet to which new rows are added continually, is there a way to write a formula that'll automatically calculate the average (or anything else, for that matter) of the values in the last x rows of a specific column?