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

@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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies