Results 1 to 2 of 2

How to sum two different columns containing specific variables

Threaded View

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

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: 5
    Last Post: 02-03-2016, 02:43 PM
  2. [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
  3. [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
  4. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  5. Adding a column with variables for specific entries
    By AndyPandy in forum Excel General
    Replies: 4
    Last Post: 02-05-2013, 04:43 AM
  6. Replies: 1
    Last Post: 08-07-2012, 07:47 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