In Excel worksheet, we can use the SUM function to calculate a list of numbers quickly and easily. However, when you want to sum numbers from 1 to n, do you have any good formula to solve this task?
For example, I will sum numbers from 1 to 150, the following formula can do you a favor, please do as this:
Enter this formula: =SUMPRODUCT(–(ROW(INDIRECT(B1&”:”&B2)))) into a blank cell where you want to get the calculated result, and then press Enter key, the numbers from 1 to 150 have been added up as following screenshot shown:
Note: In the above formula, B1 and B2 are the first and last number that you want to sum from.