ExcelBanter - Allocate from the sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Allocate from the sum (https://www.excelbanter.com/excel-worksheet-functions/193029-allocate-sum.html)

Allocate from the sum

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

Allocate from the sum

G3: =G2-B3

and copy down.

--
HTH

Bob

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

"srpavar" wrote in message
...
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