probably simple, but not for me, help please
 

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

probably simple, but not for me, help please
 

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.

probably simple, but not for me, help please
 

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

probably simple, but not for me, help please
 

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.

probably simple, but not for me, help please
 

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?

probably simple, but not for me, help please
 

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.

probably simple, but not for me, help please
 

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

probably simple, but not for me, help please
 

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.

probably simple, but not for me, help please
 

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

probably simple, but not for me, help please
 

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

- Show quoted text -

Then use my formulas as noted. In this sheet example place in F6:
=sum(B6-D6). That starts the running total.
In F7 enter =sum(F6+B7-D7). Copy that formula down column F. If they
need total counts for each column (their B25 and D25) then do not put
the formula in Column F for that row (row 25).

There is an inconsistency in their sheet. Cell D7 has a positive
number and cell D17 as a negative. Just enter positive numbers in
this column.

probably simple, but not for me, help please
 

On Feb 20, 3:03*pm, HKaplan wrote:
On Feb 20, 2:54*pm, wrote:





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.- Hide quoted text -

- Show quoted text -

Then use my formulas as noted. *In this sheet example place in F6:
=sum(B6-D6). *That starts the running total.
In F7 enter =sum(F6+B7-D7). *Copy that formula down column F. *If they
need total counts for each column (their B25 and D25) then do not put
the formula in Column F for that row (row 25).

There is an inconsistency in their sheet. *Cell D7 has a positive
number and cell D17 as a negative. *Just enter positive numbers in
this column.- Hide quoted text -

- Show quoted text -

It will not matter if you enter in and out on the same row. Try my
suggestion and you should see that it will work. Any line can have an
in or out or both.

probably simple, but not for me, help please
 

On Feb 20, 3:06*pm, HKaplan wrote:
On Feb 20, 3:03*pm, HKaplan wrote:





On Feb 20, 2:54*pm, wrote:

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.- Hide quoted text -

- Show quoted text -

Then use my formulas as noted. *In this sheet example place in F6:
=sum(B6-D6). *That starts the running total.
In F7 enter =sum(F6+B7-D7). *Copy that formula down column F. *If they
need total counts for each column (their B25 and D25) then do not put
the formula in Column F for that row (row 25).

There is an inconsistency in their sheet. *Cell D7 has a positive
number and cell D17 as a negative. *Just enter positive numbers in
this column.- Hide quoted text -

- Show quoted text -

It will not matter if you enter in and out on the same row. *Try my
suggestion and you should see that it will work. *Any line can have an
in or out or both.- Hide quoted text -

- Show quoted text -

FANTASTIC,.. THAT'S EXACTLY WHAT WE WERE LOOKING TO DO. THANKS AGAIN!