Average of the last 3 numbered cells

One way...

Please Login or Register  to view this content.

where A1:Z1 is your first row range... you can replace with 1:1 if you want to include entire row.

formula can be copied down.

With your posted data in A1:G4

This formula returns the average of the last 3 consecutive values in B2:G2:

Please Login or Register  to view this content.

Is that something you can work with?

Originally Posted by Ron Coderre

With your posted data in A1:G4

This formula returns the average of the last 3 consecutive values in B2:G2:

Please Login or Register  to view this content.

Is that something you can work with?

oOOPS.

Don't know why I didn't think of using a range instead of 3 arguments...

Mine would then be:

Please Login or Register  to view this content.

Originally Posted by ChemistB

I prefer the OFFSET function

Please Login or Register  to view this content.

ChemistB

That's a possibility...with the following caveat:
The OFFSET function is volatile, so every cell containing OFFSET recalculates
whenever *any* cell in the workbook recalcs. There is a threshhold where
the workbook becomes annoyingly sluggish. Consequently, I only use
OFFSET sparingly and only when necessary.

This is my latest list of volatile functions:
RAND, NOW, TODAY, OFFSET, CELL, INDIRECT

I believe the problem still exists when the OFFSET function is used in a
defined name. However, by keeping the use of volatile functions to an
absolute minimum, the impact should be negligible.