Results 1 to 3 of 3

Thread: sumifs dependent on data range within cells

  1. #1

    sumifs dependent on data range within cells



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

    Hello...I'm hoping someone can help me here before my laptop goes for a flying lesson!

    I need to insert an IF function at the start of the below formula so that the SUMIF only returns the sum when the date in 'Test Data'!$J:$J is between 01/02/2015 and 28/02/15

    =SUMIFS('Test Data'!$I:$I,'Test Data'!$L:$L,"<=0",'Test Data'!$D:$D,C$8)

    The trouble I seem to be having is that there is an existing VLOOKUP in 'Test Data'!$J:$J as the date is pulled from another workbook.

    Any ideas?

    Thanks

  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('Test Data'!$I:$I,'Test Data'!$L:$L,"<=0",'Test Data'!$D:$D,C$8,'Test Data'!$J:$J,">="&DATE(2015,2,1),'Test Data'!$J:$J,"<="&DATE(2015,2,28))


  3. #3
    Brilliant...works perfectly. Thank you very much NBVC

Posting Permissions

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