avarage on hard-defined-cells

  • Thread starter Thread starter johan
  • Start date Start date
J

johan

Hello!

I got a small problem, the thing is I got a simple worksheet; a name
and alot of numbers on each row.

*name1* 1 8 5 3 ...
*name2* 2 2 5 6 ...
*name3* 5 7 6 4 ...
*name4* 2 1 6 8 ...
and so on...

the numbers (columns) get more all the time.
Now, the problem is that I would like to have the avarage on, for
example, the 5 -*last* - numbers on each row.
I have no idea really how to solve this. Thanks in advance!!

// Johan
 
Johan,

This will get the average of the last 5 cells in row 1

=AVERAGE(OFFSET(A1,0,COUNT(1:1),1,-5))

Not that it includes blanks in the number to be averaged.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=AVERAGE(OFFSET($B$1,0,MATCH(9.99999999999999E+307,1:1)-CELL("Col",$B$1),1,-
5))

where the data starts at B1 (A1 houses *name1*).
 
Back
Top