One way to model it up for delivery

Target range is B13:B59
In C13: =IF(COUNT(B13)=0,"",ROWS($1:1))
In D13: =INDEX($B$13:$B$59,SMALL($C$13:$C$59,ROWS($1:1)))
Copy C13:D13 down to D59. This dynamically screens the target range in col B
for numbers, and then packs it up in col D (makes it into a contiguous range)

Then place in say, E13:
=IF(COUNT($D$13:$D$59)<5,"",
AVERAGE(OFFSET($D$13,COUNT($D$13:$D$59)-1,,-5)))

E13 will return the desired running average of the last 5 cells
that contain data within the target range
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"mrbob16" wrote:
I have a spreadsheet in cell b13 I start entering data till b59. I want to
take a running average of the last 5 cells that contain data. Not all cells
will have an entry and every 6th cell has a different formula. I also want to
move this running average to row c.