I recently upgraded my computer to a new imac from the mac mini. Some things changed in excel. I create spreadsheets with multiple sheets in my work book. The last page I use to keep a running total of each item that is listed on those pages. Normally when I am creating my formula on that last page, I would create it by typing "=sum( " and then going back to sheet one and clicking on the cell I want. After that, all I had to do was click on each sheet and it automatically knew to add the same cell on that page to the formula. So I would create my formula quickly by clicking on each sheet like that until I got to the last page before my total page. I can no longer do this on the imac. I have to physically click on each sheet, then the cell I want, then the plus sign. This causes more room for error and is very tedious considering my work load. Is there a way to make it go back to letting me create the formula more efficiently? Usually google is my go to, but I can't find anything to help!
lets say you want to add all values from all sheets from Cell A2 then wherever you want the result. put there =SUM('*'!A2) and once you click enter. The '*' will change automatically to (From To Sheets reference) . If you want to only sum specific sheets, lets say that you want add A2 of all sheets that starts with name Quarter then you put formula like this =SUM('Quarter*'!A2) so any sheet that starts with name Quarter will be in the range of the SUM. for example sheets Quarter 1, Quarter 2 and so on.
Best Response confirmed by
Raganash (New Contributor)