Hi,
I am in need of assistance!
I am trying to create a sheet which averages the last 12 numbers in a row.
The problems I am running into are:
-Sometimes there are fewer than 12 numbers in a row
-There are blank cells before, inbetween and after the ranges
(If there are fewer than 12 entries, I just need the average of whatever is there)
Many thanks
Attached is a screenshot
excelhours.PNG
Bookmarks