LinkBack URL
About LinkBacks
that's because you have zeroes in all the future weeks. get rid of the zeroes for future weeks and then use
=AVERAGE(INDEX(C3:BC3,COUNT(C3:BC3)):INDEX(C3:BC3,COUNT(C3:BC3)-9))
that's because you have zeroes in all the future weeks. get rid of the zeroes for future weeks and then use
=AVERAGE(INDEX(C3:BC3,COUNT(C3:BC3)):INDEX(C3:BC3,COUNT(C3:BC3)-9))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks