Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update SUM & AVERAGE
I have a worksheet the I use for monthly totals. For example, columns B thru
M are for Jan, Feb, Mar, etc. - In column N are the totals =SUM(B8:M8) and in column O are the averages =AVERAGE(B8:I8) Every month I have to update many rows with the current average ranges. I use the fill handle, but it still is something that I would hope could be automated. Is this possible to do? For example, once I enter the raw data into the column B, is there a formula to recognize that data and update the SUM & AVERAGE column? Thank you, Karen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
Can I set up the formula to update automatically? | Excel Worksheet Functions |