I have a dynamic range that I would like to sum for multiple consecutive worksheets. Tried =SUM(OFFSET((HK-Summary:SriLanka-Details!M27),0,0,B1+1,1)) but it doesn't work. For summing up one individual sheet, I used =SUM(OFFSET('HK-Summary'!C10,0,0,B1+1,1)) and it works. Any clues on how to set the range to the multiple worksheets?
Just use the offset formula on each sheets cells and use the sum formula to sum all the sheet of offset formula cell.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks