Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 5 5 5
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
5 15 0 20 I need a total that keeps adding up.

=A1+B1-C1

"Fernando" wrote:

Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 5 5 5
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
5 15 0 20 I need a total that keeps adding up.

The formula goes in col D. You can enter it in the first cell in column D
and then drag it down the entire column by clicking on the first cell and
holding while you drag.

"Fernando" wrote:

Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 5 5 5
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
5 15 0 20 I need a total that keeps adding up.

You are so very right and correct Sir! Serious oversight on my part, thanks
for the correction! And obviously, Col A can also use a formula. Say in A3,
enter the formula =D2, to bring down the total for the previous day.

"JLGWhiz" wrote:

The formula goes in col D. You can enter it in the first cell in column D
and then drag it down the entire column by clicking on the first cell and
holding while you drag.

"Fernando" wrote:

Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 5 5 5
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
5 15 0 20 I need a total that keeps adding up.

"Fernando" wrote:.

Sorry i guess i didn't explain well.
Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 12 7 10
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
Next day Rec 10 units 5 10 0 20
Following day Rec 15 Units ship 2 5 15 2 33
I need a total that keeps adding up.by entering a different new receiving
every day will my total will correpond to the new receiving ignoring my last
one. A" stay constant .
Hope this is more clear.
Thanks

In that case, I really do not see the need for Col A, as this never gets
added on, except the first day. However, in D1 use the formula =A1+B1-C1
In D2 use the formula =D1+B2-C2. Copy this one down as far as you wish. If
you do not like the column of "0"'s generated, modify the formula in D2 to
read =IF(A2="","",D1+B2-C2). Now, when you enter the 5 in Col A, the total
for that day will appear, and as you add receipts, it will increment, while
shippings wil decrement it

"Fernando" wrote:



"Fernando" wrote:.

Sorry i guess i didn't explain well.
Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 12 7 10
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
Next day Rec 10 units 5 10 0 20
Following day Rec 15 Units ship 2 5 15 2 33
I need a total that keeps adding up.by entering a different new receiving
every day will my total will correpond to the new receiving ignoring my last
one. A" stay constant .
Hope this is more clear.
Thanks

Thank you for your help kassie but ,let me try to explain bit further.Rows 2
,3,4,5 are a different inventory item altogheter .We have only one row to
work with and 2 colums to change constantly B and C,receiving and shipping,my
exemples are from the same row diffrent days entrys.B and C should reset to 0
after entering on total.
Hope this explain better.
thanks again
fernando
"kassie" wrote:

In that case, I really do not see the need for Col A, as this never gets
added on, except the first day. However, in D1 use the formula =A1+B1-C1
In D2 use the formula =D1+B2-C2. Copy this one down as far as you wish. If
you do not like the column of "0"'s generated, modify the formula in D2 to
read =IF(A2="","",D1+B2-C2). Now, when you enter the 5 in Col A, the total
for that day will appear, and as you add receipts, it will increment, while
shippings wil decrement it

"Fernando" wrote:



"Fernando" wrote:.

Sorry i guess i didn't explain well.
Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.

A B C D
5 12 7 10
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
Next day Rec 10 units 5 10 0 20
Following day Rec 15 Units ship 2 5 15 2 33
I need a total that keeps adding up.by entering a different new receiving
every day will my total will correpond to the new receiving ignoring my last
one. A" stay constant .
Hope this is more clear.
Thanks