Calculating column and row totals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Mahan - 13 Jan 2007 19:56 GMT

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

Reply to this Message

Roger Govier - 13 Jan 2007 21:40 GMT

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

Signature

Regards

Roger Govier

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

Reply to this Message