+ Reply to Thread
Results 1 to 7 of 7

Sum of values that meet criteria

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    London
    MS-Off Ver
    2008
    Posts
    9

    Sum of values that meet criteria

    Can someone please tell me the right formula/function required to achieve the below? I suspect it’s VLOOKUP or some kind of IF function but it’s got me stumped.

    I’d like Cell B2 in the “Outlook” tab to look at the entire table “Monthly Costs” tab, identify all instances of “Infrastructure” in column B and wherever it finds them to add up the corresponding value in Column C and return the sum of all of those numbers to Cell B2 in the “outlook” tab.

    Is this possible?

    Any help would be greatly appreciated and save some of my already diminishing hair!
    Attached Files Attached Files
    Last edited by randomraz; 07-03-2018 at 07:23 AM.

  2. #2
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Lookup and add

    It has nothing to do with lookups of any kind.

    As per forum rule #1, your thread title should be descriptive of your problem, not what you think might be the solution.

    Please edit your thread title to something on the lines of 'Sum of values that meet criteria' then we will be able to help you.

  3. #3
    Registered User
    Join Date
    08-25-2015
    Location
    London
    MS-Off Ver
    2008
    Posts
    9

    Re: Lookup and add

    Done and sorry.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,602

    Re: Sum of values that meet criteria

    So now title is self-descriptive :-)
    Use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in B2 and copy down/right
    Note zeros in Data. It's because in one sheet you have "Data" and in other "Data " (with a space at the end)
    Best Regards,

    Kaper

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,016

    Re: Sum of values that meet criteria

    I suspect all you need is this...
    =SUMIF('Monthly Costs'!$B$2:$B$11,Monthly!$A2,'Monthly Costs'!$C$2:$C$11)
    but I also suspect that there is more to your request than you have indicated. AND, you don't have an "outlook" tab in the workbook, rather you have a monthly tab.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  6. #6
    Registered User
    Join Date
    08-25-2015
    Location
    London
    MS-Off Ver
    2008
    Posts
    9

    Re: Sum of values that meet criteria

    Thank you very much Kasper, my hairline is grateful to your wisdom.

  7. #7
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,602

    Re: Sum of values that meet criteria

    Glad to hear so, and thanks for reputation point.
    Would you be so kind, to select Thread Tools from the menu link above and mark this thread as SOLVED.
    Thanks.

+ 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] Lookup: Lookup employee id and return value in cell x basued on most recent start date
    By jekeith in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-21-2018, 12:56 PM
  2. Two Lookup and Return (Lookup the column, then lookup the row)
    By Branbran10 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 04:55 PM
  3. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  4. Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  5. Replies: 2
    Last Post: 05-19-2013, 08:46 AM
  6. Replies: 1
    Last Post: 11-07-2012, 01:57 PM
  7. Replies: 7
    Last Post: 06-19-2011, 12: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