I want to total columns without typing every cell into the formula.
I also need help with if sums.
I tried =sum+(d2:d56) and it don't work and neither has any other
combination I tried.
I would also like to have the balance column in my checkbook automatically
subtract the debits and add the credits. Column d is debits or payments and
column e is credits or deposits and f is the balance column.
It has been years since I used excel or lotus.

=SUM(D:D)

Regards

Trevor


"Thomas Flaherty" <Thomas wrote in
message ...
I want to total columns without typing every cell into the formula.
I also need help with if sums.
I tried =sum+(d2:d56) and it don't work and neither has any other
combination I tried.
I would also like to have the balance column in my checkbook automatically
subtract the debits and add the credits. Column d is debits or payments
and
column e is credits or deposits and f is the balance column.
It has been years since I used excel or lotus.

Hi Thomas,
You might want to take a look at my page on inserting rows.
The worksheet formulas in the example are for a checkbook.
The first macro at the top provides for inserting rows,
and makes use of OFFSET which is very necessary if
you insert rows, delete rows, sort a range of rows.

Inserting a row will maintain the formulas, used in the row above
the insertions.

There is also a Change Event macro that will populate the
formulas on a row if you type something into column A or B
and the formulas are not already present.

Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Trevor Shuttleworth" wrote in message ...
=SUM(D:D)

Regards

Trevor


"Thomas Flaherty" <Thomas wrote in
message ...
I want to total columns without typing every cell into the formula.
I also need help with if sums.
I tried =sum+(d2:d56) and it don't work and neither has any other
combination I tried.
I would also like to have the balance column in my checkbook automatically
subtract the debits and add the credits. Column d is debits or payments
and
column e is credits or deposits and f is the balance column.
It has been years since I used excel or lotus.

to clarify & simplify previous posts:

=SUM(D2:D56) or for entire column, regardless of length =SUM(D:D) as
previously stated.

Example for checkbook balance calculations:

A B C D E
1 DATE DESC DEBITS CREDITS BALANCE
2 BAL FWD $500.00
3 5/1/2006 ATM $52.55 =E2-C3+D3
4 5/2/2006 DEPOSIT $250.00 =E3-C4+D4
5 5/3/2006 CHK 123 $100.00 =E4-C5+D5


"Thomas Flaherty" wrote:

I want to total columns without typing every cell into the formula.
I also need help with if sums.
I tried =sum+(d2:d56) and it don't work and neither has any other
combination I tried.
I would also like to have the balance column in my checkbook automatically
subtract the debits and add the credits. Column d is debits or payments and
column e is credits or deposits and f is the balance column.
It has been years since I used excel or lotus.