Hello,
So I have a column of ongoing numbers and I want to automatically find a formula that will sum the last 20 numbers as I input more into the column. For example, in the book, the last number is 33, but I will put in 34, and 35 as time goes on as shown. Is there a formula that will automatically calculate the last 20 numbers as I input more numbers over time?
Any help will be greatly appreciated! Thanks!
Book1.xlsx
Bookmarks