Hi,
I have a problem which I hope anyone can assist me with. I would like to sum the values in row K, if the variables in row E is either "Unemployed(18.2)" or "Employed (18.1)". The result to appear in cell N18. I have the current formula, but it does not want to work: =SUMIFS($K$5:$K$174;$E$5:$E$174;"Unemployed(18.2)";$E$5:$E$174;"Employed (18.1)"). Could anyone please assist? I have uploaded the sheet as well. Any guidance would be appreciated.
Bookmarks