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

    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
    123

    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
    14

    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, England
    MS-Off Ver
    365
    Posts
    15,027

    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
    Office 365
    Posts
    14,987

    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
    14

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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