Problems with a SUMIFS formula

I'm really having some trouble with Excel in that it's not behaving logically.  Essentially, what I'm trying to do is conditional sums for spending categorizations.  But when I use the formula, ...