how do I add numbers in list of columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

entered numbers in columns of excel and want to total them going horizontal
and vertical to get grand total for each column. Can you explain how to do
this?
 
For e.g.

You enter 1-10 in A1-A10
You enter 11-20 in B1-B10

So, in A11, you type SUM(A1:A10) to get Column Grand total and copy it to
B11 to get Grand column total for B

And, you type SUM(A1:B1) in C1, to get Row Grand Total and copy it to C2 to
C10
to get all Row Grand total

Hope this helps.
 
Thanks so much. appreciate it.

Makisa said:
For e.g.

You enter 1-10 in A1-A10
You enter 11-20 in B1-B10

So, in A11, you type SUM(A1:A10) to get Column Grand total and copy it to
B11 to get Grand column total for B

And, you type SUM(A1:B1) in C1, to get Row Grand Total and copy it to C2 to
C10
to get all Row Grand total

Hope this helps.
Click to expand...
 
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

Macro to add numbers in a text string 5
I can't see Grand total rows even though the option's switched on 2
Referencing a pivot tables Grand Totals Column 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Moving grand total columns in pivot table 1
Auto Fill 5
Pivot Table 'Grand Total' question, average instead of sum 4
Getting Text data using the Data - Subtotal feature 1

Back
Top