Calculating progression of a number.

  • Thread starter Thread starter rajesh
  • Start date Start date
R

rajesh

Hi,
Is there any function in Excel for calculating progression
of a given number.

For e.g.
1) Progression of number 8 will be calculated as
=1+2+3+4+5+6+7+8

2) Progression of number 15 will be calculated as
=1+2+3+4+5+6+7+8+9+10+11+12+13+14+15

The number for which I want to calculate progression will
be given by CountIf function in my formula.

Kindly help.

Thanks & regards

Rajesh
 
=SUMPRODUCT(ROW(INDIRECT("1:"&X)))

where X is a whole number and > 0 and is a whole number. You can have a
COUNTIF expression after & whose result is a whole number and is > 0.
 
Back
Top