Results 1 to 3 of 3

Thread: Need help with a formula

  1. #1

    Need help with a formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I thought Id give this a shot as I've been struggling to get the correct formula.
    I have two worksheets. examples below
    The first work sheet contains the raw date of goods sold to a supplier
    Column C - the date - 04/07/12
    Column E - the product code - BES03
    Column F - Quantity - 178

    The second work sheet is where I need to populate the information
    Column A - Product Code - BES03
    Cell D1 - Date from - 15/02/2012
    Cell E1 - Date to - 29/2/212
    Column D & E (from row 2 is merged)

    What I'm needing is if product code (Column A) falls between D1 E1 then populate with the quantity (column D & E) using the raw data rom the first worksheet

    Hope that makes sense

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =SUMIFS('Sheet1'!F:F,'Sheet1'!E:E,A2,'Sheet1'!C:C,">="&$D$1,'Sheet1'!C:C,"<="&$E$1)

    Where Sheet1 is name of the raw data sheet (change as necessary).


  3. #3
    Quote Originally Posted by NBVC View Post
    Try:

    =SUMIFS('Sheet1'!F:F,'Sheet1'!E:E,A2,'Sheet1'!C:C,">="&$D$1,'Sheet1'!C:C,"<="&$E$1)

    Where Sheet1 is name of the raw data sheet (change as necessary).
    Thanks this worked a treat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •