Formula question
I have a spreadsheet with about 50 rows that gradually will be filled up with
numbers. How can I make formula that will count and ad up only the 12 last rows at any given time? The position of the last 12 rows will here obviously change over time, since more numbers will be added frequently. Thanks very much for any help. -- Lars |
Formula question
For example, to add up the last twelve items in column A:
=SUM(OFFSET(A2,MATCH(2,1/(A2:A65536<0))-1,,-12)) this is an array formula must be entered with CNTRL-SHIFT-ENTER -- Gary''s Student gsnu200711 |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com