I need help writing a Daily Average Formula

Deristago

New Member
Joined
Sep 9, 2016
Messages
1
Howdy,

I have a problem that I can't figure out, and I'm hoping someone here can give me a hand. For the past several years I have been keeping a record of how far I walk/run/cycle each day via Excel. It has worked great for letting me see my average year by year. However, I have one Excel book where I have listed every single day's total of every year since I have begun keeping track. Here is the forumla that I have been using up to now:

=SUM(D751+C752)/751

D = total from the beginning to day 751
C = what I did for day 752
/751 is everything in ( ) divided by 752 days

It has been a great formula, except for the "/752" part, which I have to manually change....I'm at day 1,629 and have to change hundreds of days manually. I know there has got to be a better way for me to do this, I just cannot figure out how.

I'd like a formula that can do the following:

Keep a running daily average
Something that I can just cut and paste instead of changing every cell


Thank you all for giving my question a look and helping me out,

A Dude in Asia,

Deristago
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

West Man

Well-known Member
Joined
Mar 27, 2006
Messages
1,175
You don't need column D for purposes of an average. Take a look at the average function. By the way, the SUM in your formula serves no purpose
 

Watch MrExcel Video

Forum statistics

Threads
1,099,780
Messages
5,470,726
Members
406,719
Latest member
ensbana

This Week's Hot Topics

Top