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

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

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