How would I get a unique list of people that are in the Description column who have a category of Distribution in the Category column and have it sum all the debits in the Debit columns.
Basically, how do i get a list of unique items in the Description column that match a criteria (="Distribution" ) in the Category column, which in the adjacent cell I can get a 'Sum' of 2 'Sumif's of the Debit columns see attached

Distribution.xlsx

Thanks