Excel series and sequence formula needed

[sdsurf]

I need a formula to fill in incremental increase to a value total. All cels increase incrementally equal
B1 = 2
C1 = ?
D1 = ?
E1 = ?
F1 = ?
G1 = 25

Total of B1 to G1 = 50

I may need to extrapolate this out over multiple cels but all the cels will need to total 50

[HansDouwe]

Please try in C1 and copy down until E1: =B1+1
Please try in F1: =50-SUM(B1:E1)-G1

[sdsurf]

not quite
C1 - F1 need to increase equally
B1 = 2
C1 = ?
D1 = ?
E1 = ?
F1 = ?
G1 = 25

After numbers entered. All need to equal 50 H1 = sum(B1:F1)

[HansDouwe]

Please try in C1 and copy across until F1: =B1+(50-$G1-5*$B1)/10

[sdsurf]

That is good stuff but it isn't what I want (I asked the wrong question.
Second attempt
Starting at
B1 = 2
C1 = ?
D1 = ?
E1 = ?
F1 = ?

all cels increase equally and then the total of all cels = 50
I also need this to work if it is 3 cells or 10 cells

Thank you

[HansDouwe]

Please try this formula in D2 and copy across and down:

Please Login or Register  to view this content.

If this is what you want, consider adding reputation to the answer. This can be done by clicking on * Add reputation at the bottom left of the answer.