+ Reply to Thread
Results 1 to 3 of 3

Working with a range knowing the start and the end values

  1. #1
    Registered User
    Join Date
    10-28-2007
    Posts
    6

    Working with a range knowing the start and the end values

    Hello!

    I have a start value 10 and the end value 15 in cells A1 and A2 accordingly.
    I need to make Excel consider this as a range starting from 10 and ending with 15 with step 1 (the range looks like {10,11,12,13,14,15} )

    Is there a way i can apply excel functions to this range not making additional calculation in other cells first but getting the final result in a single cell?

    In particular, i want to type =sum(A1:A2) in a single cell and get the result 75=(10+11+12+13+14+15)

    Is it possible? Should i try to use an array function?

    Thank you!

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    I dont know if this is the best way of doing it, but this array formula (confirmed with CTRL+SHIFT+ENTER) seems to work:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-28-2007
    Posts
    6
    Hi BigBas!

    Thank you for the help!
    It does work but unfortunately not for decimals.
    Thanks again!

+ Reply to Thread

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