How do I set up an automatic running average in Excel

S

shantagor

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
 
S

shantagor

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

Need Help with Macro Security 1
Trying to find additional ranges outside of min, max, and average 2
Paste to excel from word - auto format problem 1
Need help with average/lookup formula 2
Automatic indexing in footnotes - solved 0
AverageIf function with multiple columns 1
calculating average handling time 7
Averaging data across a date range 1

Top