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

On Sun, 2 Mar 2008 10:06:01 -0800, 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