Forum Discussion

gailpinson's avatar
gailpinson
Copper Contributor
Nov 18, 2021

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

excel

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Nov 18, 2021

    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"

Resources