Summing multiple rows with excel based on user id

[MasterY0shi]

Good morning!
I was trying to get this thing to work and it won't. I am trying to sum multiple lines based on if it matches a user ID. These are on different sheets, the first page has the formula spot and ID numbers for reference. For example:

ID	Function
0001
0234
1234
5567

ID number	User Name	Useless information for you	Money they made
0001	Bob		500
0001	bob		(363)
0001	bob		900
0234	sally		245
1234	Barbara		695
1234	Barbara		(48)
5567	Tony		1256

But I have tried xlookup, vlookup, and index match with sum and sumif. Neither are returning the values correctly. Please assist.
You can use book1 and book2 as that will help differentiate the two.

 

[johnny51981]

What do you get when you do a
=SUMIF(Book2's ID Number (full column), Book 1's ID Number (one cell only), Book 2's Money they made (full column))

That should be all you need. The other thing that I would offer would be to check if both ID Number columns and the Money they made column are the same formatted correctly as sometimes numbers can be text.