Never mind the blanks for now.... Does this give the expected results for "complete" datasets (it's an array formula). I think it does... but I'm getting boggle-eyed!!
=SUMPRODUCT((T1:INDEX(1:1,LARGE(COLUMN(B1:T1)*(B1:T1<>""),9)))/(S1:INDEX(1:1,LARGE(COLUMN(A1:S1)*(A1:S1<>""),9)))-{1,1,1,1,1,1,1,1,1})/9
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glen if this is too much to look at now, look at it later. I'll just put it up here now as maybe it will be of help.
On another site a poster simplified 10 continuous figures with this array formula.
=AVERAGE(L1:T1/K1:S1-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks