Sum of the last (x) values in a row

  • Thread starter Thread starter Tobijohn
  • Start date Start date
T

Tobijohn

How would I get the average of the sums of the just previous 52 cells in a
row that contains more than 52 columns? TIA...
 
Try this *array* formula:

=AVERAGE(INDEX(1:1,LARGE(COLUMN(1:1)*(1:1<>""),52)):IV1)

--
Array formulas must be entered with CSE, <Ctrl> <Shift > <Enter>, instead of
the regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.

If you have less then 52 numbers, the formula will average whatever you have
entered.
 
Back
Top