Calculating column and row totals

R

Richard Mahan

Can some tell me if there is a way to set excel to automatically calculate
column or row totals in a financial worksheet?
 
R

Roger Govier

Hi
Provided the formula isn't in the column or row concerned
=SUM(A:A) will total all of column A
=SUM(1:1) will total the whole of row 1

If you want the formula at the top of column A in cell A1, you would
need
=SUM(A2:A65536) or
=SUM(B1:IV1)

Adjust references for other rows / columns
 
Top