| 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.
Looking for Excel formula
- Thread starter tul01
- Start date
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.
- Joined
- Mar 21, 2011
- Messages
- 1,960
- Reaction score
- 0
- Points
- 36
- Excel Version(s)
- 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).
=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).
caabyyc
Member
- Joined
- Dec 16, 2014
- Messages
- 52
- Reaction score
- 1
- Points
- 8
- Location
- YYC/YVR/YXX
- Excel Version(s)
- O365
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
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