I'm afraid it's the same conclusion, Bob.

There are 2 issues with your requirements which seem insurmountable to me
a. That you want an average result on every line in col C, but it is to
somehow disregard any interceding blanks in col B as part and parcel of the
"last 5" data rows
b. The "interceding" difficulty is further compounded by the presence of a
6th "average" line after each set of 5 lines reserved for data in col B which
contains a different formula in col C, and this 6th line is to be, like the
blanks in col B, somehow skipped in the desired average of the last 5 cells
with data in col B

FWIW, here's my best scenario should you decide to review your specs /
layout re-design. Supposing the data is continuous in B13 down (w/o any
interceding blank cells nor breaks every 6th line), and you want an average
of the last 5 cells with data in col B to reflect in col C, then in C13,
copied down:
=AVERAGE(OFFSET(B13,,,-MIN(COUNT(B$13:B13),5)))
will return those results. The top 4 formula cells, ie C13:C16 will return
the desired average of last 1 to 4 data cells in col B, while C17, C18, etc
down will return the "last 5".
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"mrbob16" wrote:
http://freefilehosting.net/download/42g42
hey Max I tried again to upload that problem and realized it said 5mb and i
thought it said 5kb so i didn't think it would fit but here it is and i tried
to explain what i need on the bottom of the page.

thanks again if could look at it one more time.