excel - holiday costs, sum up who paid for what

Question

A friend and I visit a new place each month. We log our costs in an excel doc. The doc looks like this:

I want to sum up the costs paid for by "M" and "L".

I'm not sure why but my formula doesn't work properly even though I think its correct. I use a combination of sumif, index and match to do this. See forumla in image.

Any suggestions?

Answer 1

You're over-complicating it, it's simply:

(B14=)    =SUMIF($C$1:$C$12,A14,$B$1:$B$12)

copy/paste at B15.

And be more generous with your girlfriend :/