Results 1 to 3 of 3

Thread: Compare date in a range and return sum of 2nd row data array

  1. #1

    Compare date in a range and return sum of 2nd row data array



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

    Hi,

    I'm trying to find better way to create formula, that would compare two dates (one is in columns, other in rows) and return sum of second column if date is same and bigger.
    See attached example.

    Maybe someone has better idea how this formula could be more universal?

    Thanks in advance.
    Test.xlsx

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

    =SUMIF($C$2:$C$17,">="&G$1,$D$2:$D$17)

    copied across


  3. #3
    Wow thanks Works perfectly.

Posting Permissions

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