Results 1 to 14 of 14

Formula to sum multiple values from table if values in other set of cells matches criteria

Threaded View

ImHorhay Formula to sum multiple... 05-15-2018, 03:00 PM
FDibbins Re: Formula to sum multiple... 05-15-2018, 03:06 PM
ImHorhay Re: Formula to sum multiple... 05-15-2018, 03:14 PM
FDibbins Re: Formula to sum multiple... 05-15-2018, 03:26 PM
ImHorhay Re: Formula to sum multiple... 05-15-2018, 03:59 PM
FDibbins Re: Formula to sum multiple... 05-15-2018, 04:02 PM
ImHorhay Re: Formula to sum multiple... 05-23-2018, 01:56 PM
FDibbins Re: Formula to sum multiple... 05-23-2018, 02:29 PM
ImHorhay Re: Formula to sum multiple... 05-23-2018, 05:46 PM
FDibbins Re: Formula to sum multiple... 05-23-2018, 05:59 PM
ImHorhay Re: Formula to sum multiple... 05-23-2018, 06:08 PM
FDibbins Re: Formula to sum multiple... 05-23-2018, 11:02 PM
ImHorhay Re: Formula to sum multiple... 05-24-2018, 01:16 AM
ImHorhay Re: Formula to sum multiple... 05-24-2018, 01:18 AM
  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    Brantford, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    28

    Formula to sum multiple values from table if values in other set of cells matches criteria

    Hello gurus,

    I've attached the file I'm attempting to work with for reference.

    I'm trying to create a formula in cell C14 that looks at the values in cells A8:A13, matches those values against corresponding data in the HC and CS per HR table, to sum the values from column D of those matching data points, kind of like a multiple vlookup/sum of lookup results, does that make sense?

    Suggestions would be greatly appreciated!

    Thanks in advance you beautiful minded geniuses :-)

    George
    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] Multiple lookup criteria and sum values based on matches.
    By skonduru in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-31-2016, 11:53 PM
  2. [SOLVED] Lookup Values which meet two or more criteria and return multiple matches horizontally
    By josetmg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-03-2015, 01:16 AM
  3. Replies: 5
    Last Post: 09-01-2014, 08:05 AM
  4. Replies: 2
    Last Post: 03-03-2014, 10:03 PM
  5. If values in 2 cells matches criteria, add text to a third cell
    By Zarkov in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2011, 03:14 PM
  6. Replies: 6
    Last Post: 04-21-2009, 07:00 PM
  7. summing table values with multiple criteria from a dynamic table
    By griffith in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-06-2005, 05:51 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