cumalative total
 

Can anybody help!!!!
I have the following Table:

A B C D E F G

Supplied Sold Totals Stock
Item 4pers 2pers 4pers 2pers 4pers 2pers

curry 50 50 20 10 30 40
fish 40 40 10 20 30 20
curry 10 10 20 30

Thats only a very small exemple of my table. Is there a way that I can get
col F and G to keep a running total (vb code or formular) of the individual
items as they are added to the table whether data are added to the supplied
or sold columns? Also it has to accommodate any additional items added to the
table. I hope it makes sense.
--
ASU

cumalative total
 

Hi ASU,

If you place the table with labels in colomn 1 and 2 and row A, you may
insert this universal formula in cell F3. Then you may copy to the right for
2pers, and down for new items.

=SUMIF($A$3:$A3,$A3,B$3:B3)-SUMIF($A$3:$A3,$A3,D$3:D3)

The $-marks are important for easily extending the table.

Good luck!

--
~roar


ASU skrev:

Can anybody help!!!!
I have the following Table:

A B C D E F G

Supplied Sold Totals Stock
Item 4pers 2pers 4pers 2pers 4pers 2pers

curry 50 50 20 10 30 40
fish 40 40 10 20 30 20
curry 10 10 20 30

Thats only a very small exemple of my table. Is there a way that I can get
col F and G to keep a running total (vb code or formular) of the individual
items as they are added to the table whether data are added to the supplied
or sold columns? Also it has to accommodate any additional items added to the
table. I hope it makes sense.
--
ASU

cumalative total
 

It doesn't seem to work. What i'm trying to acheive is, a vb code or formula
to look at column 'A' pick out, let say all the curry items and keep a
running total. As more curry items are entered, the totals are updated. I'm
looking to be able to do this for each items, new or exsisting, as they are
entered. Does this make sense!!? This table will cover the year so i might
end up with a long list of items.
--
ASU


"Roar" wrote:

Hi ASU,

If you place the table with labels in colomn 1 and 2 and row A, you may
insert this universal formula in cell F3. Then you may copy to the right for
2pers, and down for new items.

=SUMIF($A$3:$A3,$A3,B$3:B3)-SUMIF($A$3:$A3,$A3,D$3:D3)

The $-marks are important for easily extending the table.

Good luck!

--
~roar


ASU skrev:

Can anybody help!!!!
I have the following Table:

A B C D E F G

Supplied Sold Totals Stock
Item 4pers 2pers 4pers 2pers 4pers 2pers

curry 50 50 20 10 30 40
fish 40 40 10 20 30 20
curry 10 10 20 30

Thats only a very small exemple of my table. Is there a way that I can get
col F and G to keep a running total (vb code or formular) of the individual
items as they are added to the table whether data are added to the supplied
or sold columns? Also it has to accommodate any additional items added to the
table. I hope it makes sense.
--
ASU