# How to sum two different columns containing specific variables

1. ## How to sum two different columns containing specific variables

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.

2. ## Re: How to sum two different columns containing specific variables

Formula:
`Please Login or Register  to view this content.`

BSB

3. ## Re: How to sum two different columns containing specific variables

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

4. ## Re: How to sum two different columns containing specific variables

Late and I forgot the SUM initially. Nice one BSB

5. ## Re: How to sum two different columns containing specific variables

Originally Posted by ChemistB
Late and I forgot the SUM initially. Nice one BSB
Phew! You had me worried there ChemistB.

Had to go back and check that it didn't work without the initial SUM!
Thought I was missing a trick there...

BSB

6. ## Re: How to sum two different columns containing specific variables

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1