keving

Posts: n/a

calculating averages

I am sure there is a simple way!
each week I insert a number in a column, thus after 6 weeks I have A1:A6
filled in. Each week I need to take the average of the last 4 numbers. How
can I calculate this automatically without having to change the range each
time?
from Kevin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulas not calculating???	J Dizzle Fizzle	Excel Discussion (Misc queries)	1	December 31st 04 07:47 PM
CALCULATING CELLS AS A TOTAL	EDDIE	Excel Discussion (Misc queries)	4	December 23rd 04 03:27 PM
Calculating effective time from start/end date+time	Stefan Stridh	Excel Worksheet Functions	8	November 27th 04 03:50 PM
excel template for calculating trial balances and adjusting entri.	yesterdaytoday11	Excel Worksheet Functions	2	November 24th 04 06:25 PM
Calculating Net Position and Average Price	carl	Excel Worksheet Functions	6	October 31st 04 01:08 PM

All times are GMT +1. The time now is 07:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us