On Feb 20, 2:32*pm, wrote:
On Feb 20, 2:26*pm, wrote:





On Feb 20, 1:59*pm, HKaplan wrote:

On Feb 20, 1:49*pm, wrote:

probably simple, but not for me, help please...

my parents have retired form the bakery, and now make product out of a
home bakey for homeless shelter at no charge. My mom wants to keep
track of everything that is made and subsequently given away. Column C
will be the stuff thats made while column D will be the give away.
What do I put in E to make it have a running balance. The dates will
vary depending on how much or how little is requested. I made a sampel
sheet to show you, and it is posted at;http://prodarts.homestead.com/bakerygiveawaysheet.html

thanks in advance for al your help

You need to explain further. *Do you want a grand total running
balance regardless of the product made? *For instance you made bread,
cake, and cookies in different quantities and gave away different
quantities. *Do you want the running total in Column E to be the total
of all remaining product that is left in inventory (total of all
cakes, cookies etc. that remain in inventory) , or do you simply want
the balance remaining for each individual line item (125 pies made
less 50 given away = 75 pies left)?

Clarify and we can respond.

yes I want a running total, but keep in mind that the in and the out
values will/may be on different dates or seperat lines on the sheet- Hide quoted text -

- Show quoted text -

It is actually a freezer inventory, and if they keep good records they
will then know when it is time to make more product.The freezer allows
them to stock up, and the hostiles can withdraw as need be.- Hide quoted text -

- Show quoted text -

If you want to keep a running total of each remaining product (i.e. 50
cookies, 10 pies, etc.) then this needs to be reconfigured. Let me
know. The formula I just sent you simply counts total remaining
product, all product added up.