Formula or Macro for comparing duplicates and creating a sum

D

Dkeels

New Member
Joined
Feb 2, 2019
Messages
1
NameNumberAmountTotal
Brad Jones123456735
Brad Jones123456719
Brad Jones123456710
Joe Bob999999955
Steve Smith111111160
Steve Smith111111140

<tbody>
</tbody>
Hi,

I am looking for help to make a formula or macro for this spreadsheet. I am not great at excel compared to the other things I've seen on this site so be kind.
I need the total field to add any amounts in the amount field together if there are matches in the name column. So for example all of the amounts for Brad Jones are added into the Total field. There could be many different rows per person but would need them all to be added. There may also be some on the worksheet that have no matches.
Thanks for any help.

Dkeels
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Hi & welcome to MrExcel
How about
=SUMIF(A:A,A2,C:C)
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Write formula to compare planned amounts by vendor in one sheet to approved amounts by vendor in another tab based on project ID
Replies
1
Views
328
OaklandJim
O
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
539
ahaye
A
willow1985
  • Solved
VBA copy set amount of rows into forms until end of data set
2
Replies
15
Views
218
willow1985
willow1985
P
  • Solved
Calculating shortest to longest distances between Zip Codes (using latitude and longitude)
2 3
Replies
25
Views
917
pawcoyote
P
C
  • Question
Fill down part of macro does not work when only 1 or 2 rows of data
Replies
5
Views
384
CiaoKarina
C

Forum statistics

Threads
1,214,649
Messages
6,120,732
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top