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?