Is there a way to absolute reference sheets in a 3D function?
For example, if I have a function like: =SUM(Sheet1:Sheet30!A1), it sums up all the values in A1 across all the sheets. BUT, if a sheet tab is dragged to a new location, (i.e. Drag sheet30 infront of sheet 1 (beginning of WB), the function is adjusted, and it ends up calculating incorrectly!!!). I have tried typing: =SUM($Sheet1:$Sheet30!A1), but it throws out a syntax error. Any ideas concerning absoluting sheets, or is this not possible???
-
Absolute Referencing Sheets (Excel 2000 >)
- This topic has 7 replies, 4 voices, and was last updated 20 years, 4 months ago.
AuthorViewing 1 reply threadAuthorViewing 1 reply thread