Calculating column and row totals

  • Thread starter Thread starter Richard Mahan
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct to calculate total based on non-continuous columns? 1
Calculation Time 2
calculate total hours based on dates 5
Looking formula that gives total of remaining months 6
Find 2 values & return row number 1
Calculate Help 2
How to set cell value to emptry if three other columns are empty too 1
Use Macro to create excel scorecards out of excel workbooks 1

Back
Top