How do you get the sum of cells for entire columns and rows on Excel?

Question

Grand total wont work because I'm trying to get the sum of every other column. For example, I want to the sum of column B, D, & F to appear in column H. I dont want to do add individual cells because it will take too long.

Answer 1

Assuming you have data in Rows 1 through 10 do this.

In cell H1 put the formula =B1+D1+F1

Then copy the contents of cell H1 to H2 through H10. The formula will adjust the new row number automatically.

Then in the Grand Total (H11?) put =SUM(H1:H10).

That shouldn't take to long.

Answer 2

Use the auto-sum button. In the toolbar, looks like an E.
Just position your cursor on the last blank cell in the column you want to sum.

Answer 3

=sum(b1:25,d1:25,f1:25)

just hold the ctrl button