MasterY0shi
New Member
- Joined
- May 2, 2022
- Messages
- 1
- Office Version
- 365
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:
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.
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.