how do I add numbers in list of columns

A

Amadauss

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?
 
M

Makisa

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.
 
A

Amadauss

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...
 
Top