Hello,
I am currently using a 3D reference to calculate the sum of a cell reference in all other sheets however, I would like to idiot proof this process, is there a formula that will sum all other sheets (apart from the summary sheet of course)?
Currently my formula looks like this =SUM('sheet 2:sheet 3'!A1)
Bookmarks