Forum Discussion
tubegano
Mar 07, 2023Copper Contributor
SUMIF BY ID NUMBER
I have this list of repeated cases, besides I have a column with different categories (moving assistance, housing assistance, storage assistance, municipality patents and municipality discretion). Each case repeats 5 times, each time with a different category name. Then I have another column with the total spent on each category. I have another sheet with the cases (not duplicated) and I added 3 columns to sum the total amount by category in each case (only tree because the "assistance" categories are gonna be "sum" as one). I do not want to create a pivot, I believe I can use "sumifs" function but I haven't been able to succeed just yet. HELP 😞SHEET 1 (DUPLICATES)SHEET 2 
- Harun24HRBronze ContributorPlease attach the file to post so that we can download.