Sum distinct values with two criteria

Hey all,

I have a question that I believe can be solved with a combination of sum/if/frequency - but am still learning array formulas (started a couple hours ago when this problem arose) so I am posting here in the interim to see if a solution can be found by forum members before I either 1: solve it myself or 2: convince myself that it is impossible.

I have attached a file which is a sample from a database I am trying to use. I would like to sum the unique values of col B & col D for each category (col c). I have provided an example of the output I am looking for in the attached file.

I am currently looking through forums & tutorial and am trying to use an array sum(if(frequency on a concatenated column (=col B&col D) but cannot get this to work. My knowledge in excel is above average but has not required me to use array formulas (except when I could just blatantly copy a solution from the internet). Anyone care to help? An explanation of how your formula works would be interesting as well...but if you don't have time, I would like to think I could walk myself through it eventually.

Cheers
-poptcorn

Hi.

Sorry - not sure I understand. How do Loans, Mortgages and Cash relate to your data table?

Regards

If you are ok with using a helper column, Put this in E3, copied down...
=IF(COUNTIFS($B$3:B3,B3,$C$3:C3,C3)=1,D3,"")
Then use this for your totals...
=SUMIF($C$3:$C$26,B29,$E$3:$E$26)

Happy to help and thanks for the feedback