Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM FORMULAS
in column A1 i have a beginning balance and in column B2 i want to type in an
amount so column C2 will subtract B2 from A1. =A1-SUM(B2)got that. now in the next row i want to do the same and so on. the problem i am having is that when i put in next row, column C3 in rows C4 thru C100 show the amount of the last sum. i don't want this. if i havent put in an amount in column B than i don't want C to show anything. how would i accomplish this. PLEASE HELP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM FORMULAS
Will you be adding to the balance using other cells in Column A, or just
subtracting Column B from the single starting balance in A1? If just a single starting value in A1, try this in C2: =IF(B2,A$1-SUM(B$2:B2),"") And copy down as needed. If adding to balance using Column A, try this in C2: =IF(OR(A2<"",B2<""),SUM(A$1:A2)-SUM(B$2:B2),"") And copy down as needed. Caveat: Don't recommend this if you intend to calculate in excess of a couple thousand rows. It really uses XL resources. It's fine for smaller sheets. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "MICHELE" wrote in message ... in column A1 i have a beginning balance and in column B2 i want to type in an amount so column C2 will subtract B2 from A1. =A1-SUM(B2)got that. now in the next row i want to do the same and so on. the problem i am having is that when i put in next row, column C3 in rows C4 thru C100 show the amount of the last sum. i don't want this. if i havent put in an amount in column B than i don't want C to show anything. how would i accomplish this. PLEASE HELP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM FORMULAS
THANKS FOR YOU HELP WITH THIS
i will be subtracing column B from column A total of that will be in column C looks something like this: START BALANCE 500.00 AMOUNT REMAINING BALANCE 100.00 400.00 150.00 250.00 BLANK BLANK 50.00 200.00 "RagDyeR" wrote: Will you be adding to the balance using other cells in Column A, or just subtracting Column B from the single starting balance in A1? If just a single starting value in A1, try this in C2: =IF(B2,A$1-SUM(B$2:B2),"") And copy down as needed. If adding to balance using Column A, try this in C2: =IF(OR(A2<"",B2<""),SUM(A$1:A2)-SUM(B$2:B2),"") And copy down as needed. Caveat: Don't recommend this if you intend to calculate in excess of a couple thousand rows. It really uses XL resources. It's fine for smaller sheets. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "MICHELE" wrote in message ... in column A1 i have a beginning balance and in column B2 i want to type in an amount so column C2 will subtract B2 from A1. =A1-SUM(B2)got that. now in the next row i want to do the same and so on. the problem i am having is that when i put in next row, column C3 in rows C4 thru C100 show the amount of the last sum. i don't want this. if i havent put in an amount in column B than i don't want C to show anything. how would i accomplish this. PLEASE HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |