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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update SUM & AVERAGE
Why don't you just reference all the columns in the AVERAGE() function.
Excel is smart enough to ignore blank cells, and that way you don't have to change the formulas at all. They'll automatically adjust each month as you add the new month's data "Karen" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update SUM & AVERAGE
=IF(B8<"",SUM(B8:M8),"")
etc. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Karen" wrote in message ... 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 |
Reply |
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 |