I'm trying to get my excel spreadsheet to average a growing list of numbers some of which could have a zero balance. The spreadsheet consists of "due date" column (the date that a payment is due) a "date paid" column (the actual date the payment is made), a "$'s paid" column and a "number of days late" column (the number of days over the due date that the payment was made). I want the excel spreadsheet to average the figures in the "days late" column but obviously only up to the bottom row of the last entry made (and obviously the bottom row changes with each subsequent entry). I'm sure that the answer to this relatively easy but I've tried a number of options all without success. Hope someone can help with this. Many thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Averaging a Growing List
- Thread starter Stiffdog
- Start date
Say the "Days Late" values are in column D. Add a new column E for "Average Days Late." Enter the formula =AVERAGE(D$1:D2) in the second row of column E. As you copy that formula into subsequent rows of column E, the start range will remain D$1 while the end range will incrementally increase to include the new row.
Upvote
0
