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

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"