Allocate from the sum

[srpavar]

I have work sheet like mentioned below, i am trying to increase or decrease
in load column, in the rest of the column it has to allocate the figures and
match with the load column. I am trying to write a formula, can anyone please
help me in this.

GBR RSL WDJ MAN ALK BRK LOAD
250 50 0 110 0 380 790
240 50 0 90 0 360 740
240 40 0 80 0 340 700
240 40 0 80 0 340 700
230 40 0 70 0 330 670
240 40 0 80 0 350 710

 

[Bob Phillips]

G3: =G2-B3

and copy down.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)