help with excel

[ancrane]

can someone tell me what formula to use to create a range of numbers the continues from the last range based on the number used to the left of it? attached is a image of what I am hoping to do. the yellow box is the number I want to the range to start with. the red box is how big the range should be. the green box is the range. I put a few examples of what I am looking for below. Thank you!

[#2]

@ancrane 

Hi 

Take a look at the attached file. I couldn't tell from the image which columns you were using.

I put the stat value in cell C2 and in cell D5 entered the following formula and copied down

=IF(C5="","",$C$2+SUM(C$4:$C4)&"-"&$C$2+SUM(C$5:$C5)-1)

[#3]

If the StartNumber is in B1, try this formula in C3, copied down rows:
=SUM(B$1:B2)&
“-“&
SUM(B$1:B3,-1)