how do i have my formula wrap to the next row in excel

[Bobby]

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

 

[Gord Dibben]

That is not a formula to start with and you cannot wrap to the next row in any
case.

Say you have numbers in A1,B1,C1,D1,E1

In F1 enter =A1+B1-C1-D1-E1

If you posted a small sample of your data and layout, we could be more specific.


Gord Dibben MS Excel MVP

 

[FloMM2]

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]

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 (e-mail address removed)

Thank you for your time
Bobby

 

[Bobby]

I'm very sorry for not being too clear about my question.

But i give it another try
=sum A1+B1-C1-D1-E1=F1
now what i would like to do is to make the Value in F1 be a running total
through to the rest of the cell while maintaining the same formula for the
rest of the cells meaning B2 through to E2 and so on.
My reason for this is to create an expense sheet for money that spend on a
daily basis.

 

[Gord Dibben]

In F1 enter this formula.

=IF(COUNT(A1:E1)=0,"",SUM(A1:E1))

In F2 enter this formula.

=IF(COUNT(A2:E2)=0,"",F1+SUM(A2:E2))

Copy the F2 formula down the column.

Cells will look blank until you start pounding numbers into A:E


Gord

 

[FloMM2]

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]

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,D150,E1:E50)) DO YOU THINK THAT WOULD
WORK

 

[FloMM2]

Bobby,
If you use the "A1:A50" it will add or subtract the whole column.
In the first row in cell F1, put:
"=SUM((SUM($A1,$B1)-SUM($C1,$D1,$E1))"
In the second row in A2, put:
"=$F1"
Copy first row F1 into F2.
Now copy row 2 (A2 thru F2) down a couple of rows.

Add some numbers to check, to see if it gives you what you want.

If all is good, select row A thru F, copy.
The select the area to paste to, say A5 thru A50.
Select ,"Edit","Paste Special", then select "Formulas", "OK"

That should do it.
hth