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

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.

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

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.

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.

On Feb 20, 2:40*pm, HKaplan wrote:
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.- Hide quoted text -

- Show quoted text -


SORRY, I AM PROBABLY NOT EXPLAINING WELL ENOUGH. HERE IS MY MOM'S
ACTUAL SHEET WHICH I PRINTED TO A PDF SO THE COLUMN NUMBERS WOULD SHOW
UP. NOW "B" REPRESENTS PRODUCT MADE AND PUT INTO THE FREEZER, WHILE
"D' REPRESENTS WITHDRAWALS FROM THE FREEZER, AND "F" IS SUPPOSED TO
SHOW WHAT THE RUNNING BALANCE IN THE FREEZER IS. THANKS AGAIN!
http://prodarts.homestead.com/FREEZER_INVERTORY.pdf

On Feb 20, 2:40*pm, HKaplan wrote:
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.- Hide quoted text -

- Show quoted text -

I BELIEVE IT'S JUST FOR ONE PRODUCT (WHOLE WHEAT LOAVES OF BREAD), AND
IF IT TURNS OUT TO BE OTHERS THEY COULD ALWAYS DO A SEPERATE SPREAD
SHEET FOR EACH PRODUCT.

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 -

If I understand then, you simply start the first Balance cell (i.e.
E1) with a formula =sum(c1-d1).

Then for the next line, write something like this: =SUM(E1+C2-D2).
This will add the total above it to the difference of what was made or
given away on that line, whether or not you have a made or donated
entry on that line. It won't matter.

You just copy this formula down the column E for every line with an
entry.

Does that meet your needs?

On Feb 20, 2:37*pm, HKaplan 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 -

If I understand then, you simply start the first Balance cell (i.e.
E1) with a formula =sum(c1-d1).

Then for the next line, write something like this: =SUM(E1+C2-D2).
This will add the total above it to the difference of what was made or
given away on that line, whether or not you have a made or donated
entry on that line. *It won't matter.

You just copy this formula down the column E for every line with an
entry.

Does that meet your needs?- Hide quoted text -

- Show quoted text -

C1-D1 WOULD WORK IF THEY BOTH HAPPENED ON THE SAME ROW (OR SAME DATE),
BUT THIS WILL PROBABLY BE FAIRLY RARE. THEY LOAD THE FREEZER (20' X
20' X 8'), AND THEN THE HOSTILES/SHELTERS COME GET WHAT THEY NEED