Calculating sum

[JM]

Hi,

I need to create a funtion in following situation :

1st column is a product name
2nd column is average of units of each product sold
during last 12 months
3rd and so on column has a number of units sold in each
month

No I need to create a funtion that calculates the average
for last 12 months, even I add new columns between 2nd
and 3rd column.

Normally adding a column between 2nd and 3rd, will modify
the funtion in 2nd column, but thats something I don't
want to happen. I need to have relative reference to 12
columns to right from the funtion cell...

Can anyone help me??

JM

 

[xlbo]

Use the indirect function
=AVERAGE(INDIRECT("C1:N1")

this converts a string to a range and strings aren't affected by inserting columns etc