what is the correct formula to add a column with =sum

[Thomas Flaherty]

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.

 

[Trevor Shuttleworth]

=SUM(D)

Regards

Trevor

 

[David McRitchie]

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

 

[savera]

to clarify & simplify previous posts:

=SUM(D256) or for entire column, regardless of length =SUM(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