• 412K Members
• 7,445 Online
• 468K Conversations
SOLVED

New Contributor

# HELP, PLEASE! Excel on a Mac

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!

3 Replies
Solution

# Re: HELP, PLEASE! Excel on a Mac

try this trick.

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.
Highlighted

# Re: HELP, PLEASE! Excel on a Mac

@Jamil Mohammad Thank you so much!!  I don't know why I wasn't able to find that formula but it sure did help me immensely!  Thank you!!!

# Re: HELP, PLEASE! Excel on a Mac

You are most welcome.  Thanks for the feedback.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies