r/excel•
kelcha

Adding up value based on another column

solved

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
excelevator2322•
2
kelchaOP2•

Thanks! Solution Verified

2
[deleted]•

[removed]

1
kelchaOP2•

Solution verified

2
Clippy_Office_AsstMOD•

You have awarded 1 point to excelevator

^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.

1