SOLVED
Home

HELP, PLEASE! Excel on a Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-437650%22%20slang%3D%22en-US%22%3EHELP%2C%20PLEASE!%20Excel%20on%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-437650%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20upgraded%20my%20computer%20to%20a%20new%20imac%20from%20the%20mac%20mini.%26nbsp%3B%20Some%20things%20changed%20in%20excel.%26nbsp%3B%20I%20create%20spreadsheets%20with%20multiple%20sheets%20in%20my%20work%20book.%26nbsp%3B%20The%20last%20page%20I%20use%20to%20keep%20a%20running%20total%20of%20each%20item%20that%20is%20listed%20on%20those%20pages.%26nbsp%3B%20Normally%20when%20I%20am%20creating%20my%20formula%20on%20that%20last%20page%2C%20I%20would%20create%20it%20by%20typing%20%22%3Dsum(%20%22%20and%20then%20going%20back%20to%20sheet%20one%20and%20clicking%20on%20the%20cell%20I%20want.%26nbsp%3B%20After%20that%2C%20all%20I%20had%20to%20do%20was%20click%20on%20each%20sheet%20and%20it%20automatically%20knew%20to%20add%20the%20same%20cell%20on%20that%20page%20to%20the%20formula.%26nbsp%3B%20So%20I%20would%20create%20my%20formula%20quickly%20by%20clicking%20on%20each%20sheet%20like%20that%20until%20I%20got%20to%20the%20last%20page%20before%20my%20total%20page.%26nbsp%3B%20I%20can%20no%20longer%20do%20this%20on%20the%20imac.%26nbsp%3B%20I%20have%20to%20physically%20click%20on%20each%20sheet%2C%20then%20the%20cell%20I%20want%2C%20then%20the%20plus%20sign.%26nbsp%3B%20This%20causes%20more%20room%20for%20error%20and%20is%20very%20tedious%20considering%20my%20work%20load.%26nbsp%3B%20Is%20there%20a%20way%20to%20make%20it%20go%20back%20to%20letting%20me%20create%20the%20formula%20more%20efficiently%3F%26nbsp%3B%20Usually%20google%20is%20my%20go%20to%2C%20but%20I%20can't%20find%20anything%20to%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-437650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-456372%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%2C%20PLEASE!%20Excel%20on%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456372%22%20slang%3D%22en-US%22%3Etry%20this%20trick.%3CBR%20%2F%3E%3CBR%20%2F%3Elets%20say%20you%20want%20to%20add%20all%20values%20from%20all%20sheets%20from%20Cell%20A2%20then%20wherever%20you%20want%20the%20result.%20put%20there%20%3DSUM('*'!A2)%20and%20once%20you%20click%20enter.%20The%20'*'%20will%20change%20automatically%20to%20(From%20To%20Sheets%20reference)%20.%20If%20you%20want%20to%20only%20sum%20specific%20sheets%2C%20lets%20say%20that%20you%20want%20add%20A2%20of%20all%20sheets%20that%20starts%20with%20name%20Quarter%20then%20you%20put%20formula%20like%20this%20%3DSUM('Quarter*'!A2)%20%3CBR%20%2F%3E%20so%20any%20sheet%20that%20starts%20with%20name%20Quarter%20will%20be%20in%20the%20range%20of%20the%20SUM.%20for%20example%20sheets%20Quarter%201%2C%20Quarter%202%20and%20so%20on.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-481303%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%2C%20PLEASE!%20Excel%20on%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481303%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F24499%22%20target%3D%22_blank%22%3E%40Jamil%20Mohammad%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much!!%26nbsp%3B%20I%20don't%20know%20why%20I%20wasn't%20able%20to%20find%20that%20formula%20but%20it%20sure%20did%20help%20me%20immensely!%26nbsp%3B%20Thank%20you!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-481388%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%2C%20PLEASE!%20Excel%20on%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481388%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319397%22%20target%3D%22_blank%22%3E%40Raganash%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20most%20welcome.%26nbsp%3B%20Thanks%20for%20the%20feedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Raganash
New Contributor

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

@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!!!

@Raganash 

 

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