I need some assistance in creating a formula. I need to know how to create a
forumale that will average the last four enteries in a column. The problem I
have is the range to be averaged will change week to week. The sheet is an
inventory counts, and each row is that weeks use of inventory with the most
recent week being the lowest physical row (or highest numbered row).
Ie...first avg row 1-4, next avg 2-5, next 3-6, and so on.

I can average four rows, but can not get the range to change automatically.
The formula is in another sheet to show the last four weeks average useage.