Results 1 to 6 of 6

need calculation to add sums starting one less than starting number

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    TEXAS, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    need calculation to add sums starting one less than starting number

    I am trying to find a formula that will automatically add the sum.

    For example let's say I start with 10. I want to start one number below 10 & add them all up. For example, if starting number is 10 then I would take: 9+8+7+6+5+4+3+2+1. I need to be able to do this for any starting number.

    If I start at 100 it would be 99+98+97+96+96+94 all the way down to zero. If starting at 56, I would need to start adding 55+54+53+52+51+50 all the way to zero.

    Do you know a formula I can use? The starting number can be any number, but I need to start one number below the starting numbers and add each following number.
    Last edited by LANB5669; 09-27-2012 at 04:44 PM. Reason: NEED TO EDIT QUESTION

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1