+ Reply to Thread
Results 1 to 4 of 4

Volume Data from 1 sheet to another based on 2 criteria

  1. #1
    Registered User
    Join Date
    09-11-2020
    Location
    Glasgow, Scotland
    MS-Off Ver
    MS Office 365
    Posts
    2

    Question Volume Data from 1 sheet to another based on 2 criteria

    excel.PNG

    Hi Everyone,

    Could someone please help with a formula that will pull volume data from one column on a different workbook? It needs to be based one product number AND date, so if both these values are in an array it will spit out the volume. I've attached a picture for reference.

    Thank you in advance!
    Jen

  2. #2
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    11

    Re: Volume Data from 1 sheet to another based on 2 criteria

    Bascially there are many optios but you can take help of SUMPRODUCT. Write the formula as- =SUMPRODUCT(A1=Sheet2!$A$2:$A$100)*(C3=Sheet2!$C$2:$C$100),Sheet2!$D$2:$D$100)
    You can take help from below link.
    "rb.gy/k4lf3l"

  3. #3
    Registered User
    Join Date
    09-11-2020
    Location
    Glasgow, Scotland
    MS-Off Ver
    MS Office 365
    Posts
    2

    Re: Volume Data from 1 sheet to another based on 2 criteria

    Hi Sybon, Thanks for helping! I'm not looking to total these volume numbers. I'm looking to pull the value from the volume column in sheet 2 over to sheet 1 if it is product 1 and 1st Jan 2020. I'm currently doing a vlookup but its pulling 100 as a volume for every product no 1 and not pulling 200 if its product no 1 but 2nd Jan 2020. Does that make sense?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,539

    Re: Volume Data from 1 sheet to another based on 2 criteria

    Hello jennifer.muirhead and Welcome to Excel Forum.
    Sybon's formula is basically correct, although it would be easier to know which cells to reference if we could see an .xlsx file (instructions in banner at top of page) rather than a screen shot that is not showing columns nor rows.
    As you are new to this site I have provided a file.
    Assuming "Product Number" is in cell A1 on both sheets put the following into cell D2 on sheet 1 and copy down: =SUMPRODUCT((A2=Sheet2!$A$2:$A$100)*(C2=Sheet2!$C$2:$C$100),Sheet2!$D$2:$D$100)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Formula needed to calculate monthly sales volume from one sheet to another based on dates
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2017, 11:32 AM
  2. Replies: 0
    Last Post: 05-02-2016, 07:59 AM
  3. [SOLVED] How to show summay sheet with large volume of data
    By jimd1768 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2015, 09:55 AM
  4. [SOLVED] Index/Match Multiple Criteria: Item # & Volume Level Pricing Relative to Specific Volume
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2014, 09:28 AM
  5. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  6. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  7. Creating a volume chart based on HH:MM:SS data.
    By Wolfman81 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-01-2009, 06:29 AM

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