Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating running total.
hello,
I want to do an inventory. I want to have two cells, one to put quantity recieved and it to appear and add whats already in the second colum. Example, in quantity total I have 100 items. I want to beable to put 50 in quantity received and have quantity total change to 150. Thank You |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating running total.
Hi,
Let's say you have in column A received, in column B Pick up, in column C total Let's assume that in cell C1 you have the initial inventory = 100, in cell C2 enter =C1+A2-B2 and copy all the way down "Danlet" wrote: hello, I want to do an inventory. I want to have two cells, one to put quantity recieved and it to appear and add whats already in the second colum. Example, in quantity total I have 100 items. I want to beable to put 50 in quantity received and have quantity total change to 150. Thank You |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating running total.
I have kinda the same question with a twist. I'd like my column C (which in
my case is my checkbook balance) to not repeat the same number in all cells that have the formula copied below it. Example, if my balance is $100 in column C, and I don't enter anymore checks beyond the last check number, then I'd rather not see the same balance shown in every row of Column C. In other words, I'd only like column C to have an entry in it if something was entered in columns and or B. Is there a way to do that? Thanks..............Paul C. "Eduardo" wrote in message ... Hi, Let's say you have in column A received, in column B Pick up, in column C total Let's assume that in cell C1 you have the initial inventory = 100, in cell C2 enter =C1+A2-B2 and copy all the way down "Danlet" wrote: hello, I want to do an inventory. I want to have two cells, one to put quantity recieved and it to appear and add whats already in the second colum. Example, in quantity total I have 100 items. I want to beable to put 50 in quantity received and have quantity total change to 150. Thank You |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating running total.
Check number starting at A2
Amounts starting at B2 Enter start balance in C1 In C2 enter =IF(B2="","",C1-B2) Copy down as far as you wish. Note: if making a deposit in Column B enter it as a negative. Gord Dibben MS Excel MVP On Wed, 4 Mar 2009 17:33:33 -0500, "Paul Calcagno" wrote: I have kinda the same question with a twist. I'd like my column C (which in my case is my checkbook balance) to not repeat the same number in all cells that have the formula copied below it. Example, if my balance is $100 in column C, and I don't enter anymore checks beyond the last check number, then I'd rather not see the same balance shown in every row of Column C. In other words, I'd only like column C to have an entry in it if something was entered in columns and or B. Is there a way to do that? Thanks..............Paul C. "Eduardo" wrote in message ... Hi, Let's say you have in column A received, in column B Pick up, in column C total Let's assume that in cell C1 you have the initial inventory = 100, in cell C2 enter =C1+A2-B2 and copy all the way down "Danlet" wrote: hello, I want to do an inventory. I want to have two cells, one to put quantity recieved and it to appear and add whats already in the second colum. Example, in quantity total I have 100 items. I want to beable to put 50 in quantity received and have quantity total change to 150. Thank You |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating running total.
Hey Gord. I got it to work the way I needed it. Thanks.............Paul C.
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... Check number starting at A2 Amounts starting at B2 Enter start balance in C1 In C2 enter =IF(B2="","",C1-B2) Copy down as far as you wish. Note: if making a deposit in Column B enter it as a negative. Gord Dibben MS Excel MVP On Wed, 4 Mar 2009 17:33:33 -0500, "Paul Calcagno" wrote: I have kinda the same question with a twist. I'd like my column C (which in my case is my checkbook balance) to not repeat the same number in all cells that have the formula copied below it. Example, if my balance is $100 in column C, and I don't enter anymore checks beyond the last check number, then I'd rather not see the same balance shown in every row of Column C. In other words, I'd only like column C to have an entry in it if something was entered in columns and or B. Is there a way to do that? Thanks..............Paul C. "Eduardo" wrote in message ... Hi, Let's say you have in column A received, in column B Pick up, in column C total Let's assume that in cell C1 you have the initial inventory = 100, in cell C2 enter =C1+A2-B2 and copy all the way down "Danlet" wrote: hello, I want to do an inventory. I want to have two cells, one to put quantity recieved and it to appear and add whats already in the second colum. Example, in quantity total I have 100 items. I want to beable to put 50 in quantity received and have quantity total change to 150. Thank You |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating running total.
Good to hear.
Gord On Wed, 4 Mar 2009 22:37:51 -0500, "Paul Calcagno" wrote: Hey Gord. I got it to work the way I needed it. Thanks.............Paul C. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Check number starting at A2 Amounts starting at B2 Enter start balance in C1 In C2 enter =IF(B2="","",C1-B2) Copy down as far as you wish. Note: if making a deposit in Column B enter it as a negative. Gord Dibben MS Excel MVP On Wed, 4 Mar 2009 17:33:33 -0500, "Paul Calcagno" wrote: I have kinda the same question with a twist. I'd like my column C (which in my case is my checkbook balance) to not repeat the same number in all cells that have the formula copied below it. Example, if my balance is $100 in column C, and I don't enter anymore checks beyond the last check number, then I'd rather not see the same balance shown in every row of Column C. In other words, I'd only like column C to have an entry in it if something was entered in columns and or B. Is there a way to do that? Thanks..............Paul C. "Eduardo" wrote in message ... Hi, Let's say you have in column A received, in column B Pick up, in column C total Let's assume that in cell C1 you have the initial inventory = 100, in cell C2 enter =C1+A2-B2 and copy all the way down "Danlet" wrote: hello, I want to do an inventory. I want to have two cells, one to put quantity recieved and it to appear and add whats already in the second colum. Example, in quantity total I have 100 items. I want to beable to put 50 in quantity received and have quantity total change to 150. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
Calculating a sum with running total and replacement | Excel Worksheet Functions | |||
Is there any way of calculating a running total within a single cell in a column | New Users to Excel |