LinkBack URL
About LinkBacks
excelstudent24 
Or:
=SUM(INDIRECT("Sheet1!$C" & (ROW(L26)-26)*7+1 &" :$BB"& (ROW(L26)-26)*7+7))
Or:
=SUM(INDIRECT("Sheet1!$C" & (ROW(L26)-ROW(L$26))*7+1 &" :$BB"& (ROW(L26)-ROW(L$26))*7+7))
Depending on whether or not you want to see the numbers change.
Regards
Or:
=SUM(INDIRECT("Sheet1!$C" & (ROW(L26)-26)*7+1 &" :$BB"& (ROW(L26)-26)*7+7))
Or:
=SUM(INDIRECT("Sheet1!$C" & (ROW(L26)-ROW(L$26))*7+1 &" :$BB"& (ROW(L26)-ROW(L$26))*7+7))
Depending on whether or not you want to see the numbers change.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks