Hey FloMM2

Okay it seems that my head is full of water..... but what
are you saying to is to use this formula in Cell F1
=SUM((SUM(A1,B1)-SUM(C1,D1,E1)) and then in cell A2 put =F1.

I did all that you instructed but when i put the numbers in the remaining in
cell B2 .....through to E2 the calculation does not continue on to F2 on so
i'm probably doing something wrong.
I even tried to copy the formula from F1 down through the F colum and copy
F1 down through the A colum and still it doesn't work. i'm also should tell
you that i'm trying to do this in Office 07 i don't know if that makes any
difference.
would it be possible to try
=SUM((SUM(A1:A50,B1:B50)-SUM(C1:C50,D1:D50,E1:E50)) DO YOU THINK THAT WOULD
WORK

"FloMM2" wrote:

Bobby,
OK. Once the formulas are set in the first row ( as in previous email),
what you need to do is copy the formula down as far as you need, so the
formulas do not change.
So this is what you need to do:
In F1 cell, Add a place keeper to formula.
"=SUM((SUM(A1,B1)-SUM(C1,D1))" becomes
"=SUM((SUM($A1,$B1)-SUM($C1,$D1))"
In cell "A" in the next row down would be the formula would change:
"=F1" OLD
'=$F1" new

This keeps the column from changing but allows the rows to change as you
need.
Copy the row, in my example, A1 to F1. Down two or three rows. Put some
numbers in and check the results. It should be fine, if so copy down to your
hearts content.

hth
If you need anything else, let me know.
"Bobby" wrote:

Hello to you.
Yes that is exactly what i would like to do but the thing is using the same
examples can you give the break down of how to get the F1 formula to to A2
with the running total.... i know how to create the formula for A1 ...... on
to F1 but then i'm stuck.
Also can you please e-mail me the instruc... to

Thank you for your time
Bobby

"FloMM2" wrote:

Bobby,
If I understand the question:
Column A Column B Column C Column D Column E Column F
Number Number Number Number Number End Total
Ex. $100 $200 $56 $24.50 $1.50 $218.00
$218 $200 $56 $24.50 $1.50 $336

In cell "F" would be the formula,"=SUM(SUM(A1,B1)-SUM(C1,D1))"
In cell "A" in the next row down would be the formula, "=F1"

This way the next entry would start off with the previous total.

hth

"Bobby" wrote:

Hello to anyone that can help me.

I'm trying to use excel to create a payment chart for my bills, so i would
like to know how to have this formula wrap to the next row with the ending
total.

A+B-C-D-E=F
and have the F wrap as the total wrap back to A and continue on through the
cells
Please help.

Thank you for your time.

Bobby