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!
Bookmarks