Forum Discussion
trying to create a total tab that shows sum of values for each ID#
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
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"