How to sum two different columns containing specific variables

[ramatthews]

Hi All,

I really hope someone can be of assistance. This would be greatly appreciated.


If I refer to cell N22 on the sheet attached, I would like to add the cost for column J for certain variables in column E and I. My formula currently is =SUM(SUMIFS($J$5:$J$174;$E$5:$E$174;{"Unemployed(18.2)";"Employed (18.1"};$I$5:$I$174;"Stipend")) , but this does not work. Sorry for the question, but I am getting lost with the amount of variables.

[Sam Capricci]

I would think this would work =SUMIFS($J$5:$J$174,$I$5:$I$174,"Stipend",$E$5:$E$174,"Employed(18.1)")+SUMIFS($J$5:$J$174,$I$5:$I$174,"Stipend",$E$5:$E$174,"Unemployed(18.2)")