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.
Formula:
Please Login or Register to view this content.
BSB
Try this
=SUM(SUMIFS($K$5:$K$174,$E$5:$E$174,{"Unemployed(18.2)","Employed (18.1)"}))
By putting them in as an array (inside {}) it becomes an OR instead of an AND
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Late and I forgot the SUM initially. Nice one BSB
Phew! You had me worried there ChemistB.Originally Posted by ChemistB
Had to go back and check that it didn't work without the initial SUM!
Thought I was missing a trick there...
BSB
Thank you Very much!!! If I refer to cell N22, 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. Can you once again please assist?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks