Support Board
Date/Time: Tue, 04 Mar 2025 11:18:18 +0000
Post From: Spreadsheet study. Sum of values with irregular row intervals.
| [2021-11-30 22:10:59] |
| Mario Escalante - Posts: 21 |
|
Hello for a detailed explanation of the problem please go to: https://www.mrexcel.com/board/threads/sum-of-values-with-irregular-row-intervals.1188950/ I'm trying to use the following formula to sum values from different columns that are also at different row intervals. =IF(B1=0,0,B1+INDEX(A:A,MIN(IF(A1:A10,ROW(A1:A10))))) the formula works just fine on excel and I don't see why it wouldn't work on SC since all those functions are supported by SC. Any comments about this behavior or even a different approach for resolving my problem is well received. Thank you for the help. |