four week average

  • Thread starter Thread starter tjames
  • Start date Start date
T

tjames

I have a spreadsheet that I add numbers in to weekly. I have one
column where I do an average of the past 4 weeks. Is there a way to
have the column update when I add the new numbers in the next week?
 
Hi
you could use something like
=IF(A4<>"",your_average_formula,"")
in row 4 and copy this down
 
You must log in or register to reply here.

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

Running Average Excel 2007 5
Averaging the two most recent entries in a column 13
automatically average the last 4 columns 10
Changing Average - Ongoing for Excel 2007 2
Average 2
moving average & rank 3
Average Goal Calculation 4
Average over non-existing numbers 7

Back
Top