Averaging a Growing List

Stiffdog

New Member
Joined
Jul 29, 2010
Messages
3
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,122,600
Messages
5,597,114
Members
414,125
Latest member
iQQ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top