+ Reply to Thread
Results 1 to 4 of 4

Need to fill a cell using SUMIF but searching a cell using VLOOKUP

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    Arizona
    MS-Off Ver
    Not sure. Current version. Also using Google Sheets
    Posts
    2

    Need to fill a cell using SUMIF but searching a cell using VLOOKUP

    I am building a spreadsheet that uses a vlookup in the Master sheet. I have a dropdown to select a department. The department number is then filled in via a vlookup into an adjacent cell. On another sheet, I need that vlookup number to be used as a search for a dollar total.

    I have attached the sheet. The PRINT SHEET is where my difficulty comes in. I want column C to auto-sum all matches to column B. Column B numbers are being drawn from MASTER where column C is populated by a VLOOKUP.

    Sorry for any confusion in my writing this. Hopefully the sheet will help make sense.

    Thanks for any and all assistance!!
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Need to fill a cell using SUMIF but searching a cell using VLOOKUP

    why are you hand entering the value you are summing in that sumif formula like this... =SUMIF(MASTER!C4:C1000,"*6105.011*",MASTER!H4:H1000)
    why not just point it to B3 like this... =SUMIF(MASTER!C4:C1000,B3,MASTER!H4:H1000)?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-09-2020
    Location
    Arizona
    MS-Off Ver
    Not sure. Current version. Also using Google Sheets
    Posts
    2

    Re: Need to fill a cell using SUMIF but searching a cell using VLOOKUP

    Hey Sambo kid, this seems to resolve my problem!

    Thanks so much for the quick and amazing response!

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Need to fill a cell using SUMIF but searching a cell using VLOOKUP

    Glad I could help, AND thank you for the rep! 🙂

+ 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] Multiple criteria grouped to one cell using Sumif and Vlookup
    By JHSVic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2020, 11:49 AM
  2. [SOLVED] Vlookup - Searching for text within a cell
    By bradro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2017, 05:08 PM
  3. VBA search engine with auto fill cell and for searching in 3 column
    By avogadrow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2014, 05:36 PM
  4. Replies: 2
    Last Post: 03-03-2014, 05:43 PM
  5. vlookup and sumif - based on cell content
    By ln2012 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2013, 06:25 PM
  6. [SOLVED] fill column with vlookup formula to other workbook that depends on cell value
    By knick12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2012, 03:11 AM
  7. Automatic cell fill, based on answer from VLOOKUP function
    By cptwhite in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-04-2008, 12:44 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