| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Column, Keep Average range
I'm working on a sheet where I have the average function in column A
"=AVERAGE(B3:K3)" and it is averaging columns B-K. This is for tracking data over the past several weeks. I would then like to insert a column at B, but still average columns B-K, but the Average function in column A updates to "=Average(C3:L3)" when the new column is added. I have tried using "=Average($B$3:$K$3), but the formula still updates when the column is added. How can I add a column, but keep the Average function on the cells B-K? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Column, Keep Average range
Hi,
Try =AVERAGE(INDIRECT("B3:K3")) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "pwarrenphoto" wrote: I'm working on a sheet where I have the average function in column A "=AVERAGE(B3:K3)" and it is averaging columns B-K. This is for tracking data over the past several weeks. I would then like to insert a column at B, but still average columns B-K, but the Average function in column A updates to "=Average(C3:L3)" when the new column is added. I have tried using "=Average($B$3:$K$3), but the formula still updates when the column is added. How can I add a column, but keep the Average function on the cells B-K? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a text in column A and calculoate the average for every gro | Excel Discussion (Misc queries) | |||
| AVERAGE a range in a column if another column's range equals a val | Excel Discussion (Misc queries) | |||
| Insert a column within a range of cells | Excel Worksheet Functions | |||
| Formula to take average from column range matching another | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
