trying to create a total tab that shows sum of values for each ID#

%3CLINGO-SUB%20id%3D%22lingo-sub-2980977%22%20slang%3D%22en-US%22%3Etrying%20to%20create%20a%20total%20tab%20that%20shows%20sum%20of%20values%20for%20each%20ID%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2980977%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20'Total%22%20tab%20that%20shows%20the%20sum%20of%20all%20Equip%20ID%23s.%26nbsp%3B%20Each%20tab%20doesnt%20have%20the%20exact%20same%20list%20of%20Equip%20ID%23s%20so%2C%20it%20has%20to%20look%20for%20that%20specific%20ID%23%20on%20each%20tab%20then%20show%20the%20total%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2980977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981245%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20create%20a%20total%20tab%20that%20shows%20sum%20of%20values%20for%20each%20ID%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981245%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222903%22%20target%3D%22_blank%22%3E%40gailpinson%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20propose%20you%20convert%20the%20indivual%20lists%20in%20the%20separate%20worksheets%20into%20formatted%20tables%20(menu%20Home%20%7C%20Format%20as%20Table).%3C%2FP%3E%3CP%3EThen%20load%20all%20sheets%20into%20Power%20Query%2C%20combine%20them%20and%20either%20group%20them%20directly%20in%20Power%20Query%20or%20make%20a%20Pivot%20table%20out%20of%20it.%3C%2FP%3E%3CP%3EIn%20the%20attached%20file%2C%20I%20created%20an%20example.%20To%20update%20the%20total%20sheet%2C%20just%20do%20a%20right-click%20within%20the%20table%20and%20select%20%22Refresh%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need a 'Total" tab that shows the sum of all Equip ID#s.  Each tab doesnt have the exact same list of Equip ID#s so, it has to look for that specific ID# on each tab then show the total

1 Reply

Hi @gailpinson,

 

I propose you convert the indivual lists in the separate worksheets into formatted tables (menu Home | Format as Table).

Then load all sheets into Power Query, combine them and either group them directly in Power Query or make a Pivot table out of it.

In the attached file, I created an example. To update the total sheet, just do a right-click within the table and select "Refresh"