Results 1 to 3 of 3

Thread: Looking for Excel formula

  1. #1
    Neophyte tul01's Avatar
    Join Date
    Jan 2020
    Posts
    1
    Articles
    0
    Excel Version
    2013

    Looking for Excel formula



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

    Parameter Value Answer
    3.25 1 10
    2
    3
    4
    2.15 5 23
    6
    4
    8
    3.25 8 21
    9
    4
    4.5 4 4


    Looking for Formula to get the Answer of above problem where same parameter repeats number of time but sum only need when the first parameter is end not till end.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,699
    Articles
    0
    Excel Version
    O365
    This array formula should do it.

    =IF($A3<>"",SUM(B3:INDEX($B$1:$B$20,MIN(MIN(IF($A4:$A$20<>"",ROW($A4:$A$20)-1,99^99),ROWS($A$1:$A$20))))),"")

    Change the 20 in the cell references to your last row (plus at least 1).

  3. #3
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    37
    Articles
    0
    Excel Version
    2016
    For reference

    Assuming valid date is in A1:B999,

    C1=IF(A1="","",SUM(OFFSET(B1,,,MIN(IF(A2:$A$999<>"",ROW(A2:$A$999)-ROW(),999)),1))) Control+Shift+Enter, copy down

Posting Permissions

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