+ Reply to Thread
Results 1 to 7 of 7

Sumif and Vlookup (I think)

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    Oklahoma city, Ok
    MS-Off Ver
    2010
    Posts
    11

    Sumif and Vlookup (I think)

    I have a list of locations and need to get a sum of multiple ros from another tab "Master OPC & CO".
    Both tabs will be sorted multiple ways so I think I need to add vlookup to make this formula work.

    Bozeman row is what I am looking for in this function.

    Thank you

    Brad
    Attached Files Attached Files
    Last edited by abadbrad; 04-21-2020 at 12:11 PM. Reason: Solved

  2. #2
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    113

    Lightbulb Re: Sumif and Vlookup (I think)

    Hi Abadbrad

    You had inverted the SUM.IF function

    Try :
    Please Login or Register  to view this content.

    Sorry it's in French

    Please Login or Register  to view this content.
    Regards,
    Brian
    Last edited by BrianM45; 04-20-2020 at 04:17 PM.
    If you are satisfied with my answer, please add reputation

  3. #3
    Registered User
    Join Date
    04-25-2017
    Location
    Oklahoma city, Ok
    MS-Off Ver
    2010
    Posts
    11

    Re: Sumif and Vlookup (I think)

    Thank you for your quick resoponce and answer.
    But I am still having issues. I changed the front to =sumif and I'm still having issues.
    Would you mind sending me an atttchemtnt with the working formula?
    Again Thank you.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    7,828

    Re: Sumif and Vlookup (I think)

    You also need to change the ; to , like
    =SUMIF(OPC_CO[Location],[@[Project Location]],OPC_CO[CO Totals])

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,483

    Re: Sumif and Vlookup (I think)

    with a pivot table.

    see the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  6. #6
    Registered User
    Join Date
    04-25-2017
    Location
    Oklahoma city, Ok
    MS-Off Ver
    2010
    Posts
    11

    Re: Sumif and Vlookup (I think)

    Thank you both for your help.
    I tried and failed. I am slowly learning the wonders of Excel!!
    Thank you again for all the support!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,656

    Re: Sumif and Vlookup (I think)

    Administrative Note:

    Next time you start a thread, choose a better title, please.

    The thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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] Sumif/vlookup
    By Valj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2018, 11:17 PM
  2. Using VLOOKUP & SUMIF ??
    By SSStacy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-24-2018, 01:44 PM
  3. [SOLVED] vlookup and sumif vlookup returns yes and is also matching something else with "errors"?
    By mecexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2015, 03:45 PM
  4. [SOLVED] Vlookup + sumif
    By Vehat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2012, 03:02 PM
  5. VLOOKUP and SUMIF???
    By reneedahl in forum Excel General
    Replies: 2
    Last Post: 03-21-2012, 07:34 PM
  6. Excel 2007 : SumIf with a vlookup?
    By stevetothink in forum Excel General
    Replies: 3
    Last Post: 11-01-2010, 03:27 PM
  7. vlookup and sumif
    By ninja.andy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2010, 04:54 PM

Tags for this Thread

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