If your value of interest is in A1, try:What sum function would I use to sum from 1 to the specified number. For example, if my number were 5. I would want a formula to sum 1+2+3+4+5 and return 15.
Thanks,
The sum of an arithmetic series is (number of terms)(first term + last term)/2