Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding an ongoing value to an Average
I am running a yearly total for a weekly average on a new worksheet
every week as follows: =AVERAGE('6-23-05'!F18,'6-30-05'!F18,'7-7-05'!F18,'7-14-05'!F18, '7-21-05'!F18,'7-28-05'!F18,'8-04-05'!F18,'8-11-05'!F18,F18) When I copy the blank template to add a new week, I have to manually add the cell of the previous week to the equation. Is there a way to automate this? Eventually, this value is going to get incredibly long, so I'm thinking there must be a better way. Obviously I'm not terribly bright when it comes to Excel, so any help would be appreciated. Thanks, -John |
#2
|
|||
|
|||
Use 2 dummy sheets first and last, then add all the sheets in-between
=AVERAGE(First:Last!F18) -- Regards, Peo Sjoblom (No private emails please) "biggcheese" wrote in message ups.com... I am running a yearly total for a weekly average on a new worksheet every week as follows: =AVERAGE('6-23-05'!F18,'6-30-05'!F18,'7-7-05'!F18,'7-14-05'!F18, '7-21-05'!F18,'7-28-05'!F18,'8-04-05'!F18,'8-11-05'!F18,F18) When I copy the blank template to add a new week, I have to manually add the cell of the previous week to the equation. Is there a way to automate this? Eventually, this value is going to get incredibly long, so I'm thinking there must be a better way. Obviously I'm not terribly bright when it comes to Excel, so any help would be appreciated. Thanks, -John |
#3
|
|||
|
|||
Peo,
Thanks for the reply and sorry I didn't respond back sooner. Perhaps I am still doing something wrong, but when I add the equation =AVERAGE(First:Last!F18) I get a "divide by zero" error message. I am using blank templates for the "First" and "Last" sheets. Peo Sjoblom wrote: Use 2 dummy sheets first and last, then add all the sheets in-between =AVERAGE(First:Last!F18) -- Regards, Peo Sjoblom (No private emails please) "biggcheese" wrote in message ups.com... I am running a yearly total for a weekly average on a new worksheet every week as follows: =AVERAGE('6-23-05'!F18,'6-30-05'!F18,'7-7-05'!F18,'7-14-05'!F18, '7-21-05'!F18,'7-28-05'!F18,'8-04-05'!F18,'8-11-05'!F18,F18) When I copy the blank template to add a new week, I have to manually add the cell of the previous week to the equation. Is there a way to automate this? Eventually, this value is going to get incredibly long, so I'm thinking there must be a better way. Obviously I'm not terribly bright when it comes to Excel, so any help would be appreciated. Thanks, -John |
#4
|
|||
|
|||
Dear Biggcheese I tired it myself and it seems to be working o! Give it another go and let us know! Best regards Deepak -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=395520 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel |