How do I set up an automatic running average in Excel

G

Guest

I have tried to find the answer How do I set up an automatic running average
in Excel several times and had no luck. Can anyone help?
 
B

Biff

Hi!

What's your definition of a running average?

What do you want to average and where is it?

Biff
 
G

Guest

I am using my Excel to enter vehicle mileage and fuel cost information. I
added a row for the overall average of fuel mileage for all fuel entries and
would like Excel to keep the overall average for me without having to enter
it manually.
Thanks!
 
B

Biff

Hi!

Trying to get detailed info is sometimes worse than pulling teeth! <g>

If your mileage data is in column A and you add new data to it on a regular
basis:

=AVERAGE(A:A)

Just don't put the formula in column A.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Average dates help 0
Consistantly average 180 data cells 9
Trying to find additional ranges outside of min, max, and average 2
Averaging data across a date range 1
Calculate AVERAGe with #MISSING! 2
need quick help averaging multiple rows 3
played win percentage for averages for a league. 1
Need to get Address() to Average Function Range argument 6

Top