I have a spreadsheet with long columns of numbers, and I really want a way of having a single formula in a cell at the top of each column which sums the last six items in the column. Sounds simple doesn't it - but it is really doing my head in at the moment.
I'm sure that one of you clever guys out there has come across this before - any ideas that would point me in the right direction?
I'm sure that one of you clever guys out there has come across this before - any ideas that would point me in the right direction?