# Working with a range knowing the start and the end values

1. ## 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. 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. Hi BigBas!

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

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

#### 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