Extracting averages

[Mette Dencker]

Hi,

can anybody help me on this problem: I have a column with a LOT of numbers
and I want to know the average of each three (in for instance A1-A3, A4-A6,
A7-A9 and so on) and put these average values in a new column (say, B), but
this new column should not contain any blanc fields, ie. I want the length
of new column (B) to be only one-third of the length of the original column
(the A-column)...

Thank you
/Mette

 

[Nick Ward]

Mette

You need to use the OFFSET function. If you send me your
email address to (e-mail address removed), I will send you
an example spreadsheet.

Cheers
Nick.