Adding up value based on another column
Alright, so I have a column with names and a column with amounts. I need to add up the amounts for each name. The names have first and last in one column.
So names are in column A amounts are in Column G And I need to total all of column G for each column A.
The names change and I’ve got hundreds of names. Ideally I could have this on a separate sheet?
I just need to pull the name, and the total for each name.
I’m at a loss for how to do it without manually entering the name which would be very time consuming.
I hope I explained this correctly
Posted Dec 20, 2020, 10:01 PM UTC
15
Use a PIVOT table
Thanks! Solution Verified
[removed]
Solution verified
You have awarded 1 point to excelevator
^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.