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.
 
Thanks, I'll give it a shot. I wish I knew enough to understand "HOW" in
works...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for a sum! 4
Conditional SUM help 3
Sum coloured cells 6
In a sales quote sheet - sum totals by license type 1
Try to be more precise 4
Xbox Series X anomaly (sort of) 4
values in a variable range? 1
Excel Complex Summing 3

Back
Top