+ Reply to Thread
Results 1 to 6 of 6

How to sum two different columns containing specific variables

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    South Africa
    MS-Off Ver
    office for Mac
    Posts
    97

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,454

    Re: How to sum two different columns containing specific variables

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,580

    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
    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

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,580

    Re: How to sum two different columns containing specific variables

    Late and I forgot the SUM initially. Nice one BSB

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,454

    Re: How to sum two different columns containing specific variables

    Quote Originally Posted by ChemistB View Post
    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. #6
    Registered User
    Join Date
    05-04-2015
    Location
    South Africa
    MS-Off Ver
    office for Mac
    Posts
    97

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to sum two different columns containing specific variables
    By ramatthews in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2016, 09:52 AM
  2. [SOLVED] Copy specific columns to specific columns in another worksheet
    By mahat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:24 AM
  3. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  4. Replies: 1
    Last Post: 08-07-2012, 07:47 PM
  5. Generate List based on specific Variables being Met
    By swankrain in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2010, 04:55 PM
  6. Declaring specific userform variables/checkbox
    By HOT97ECLIPSEGSX in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 06-21-2010, 03:09 PM
  7. IF 3 variables then return a specific #
    By rkerns1 in forum Excel General
    Replies: 6
    Last Post: 04-01-2009, 06:32 PM

Bookmarks

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