Download Excel Start File: [ Ссылка ]
Download file: [ Ссылка ]
1. See two array formulas to add all the numbers after the last zero.
2. See the functions SUMPRODUCT, SUM, INDEX, MATCH, ROW.
3. See one formula that uses Boolean Logic
4. See one Formula that uses a dynamic range created by the INDEX function
5. T. Valko at Mr Excel Message Board
