How to automatically add numbers up in excel 2007?

Question

How would i be able to add up numbers

My rows consist of Month dates on the Vertical row

And monday to sunday on the horizontal row

I want to add that up to row 33 so it gives me a total

I'm trying to keep track of my new computer money

thanks :)

Answer 1

There are two ways I know to do this, both with the SUM function.

First, you can add a range within a column by using =SUM(Ax:Ay) where x is the first and y is the last cell in the series, and A is the column letter. You can also add arbitrary cells by listing the cells seperated by commas i.e. =SUM(A1,F62,Q337).

Answer 2

You will need to use the SUM() function in the cell you want the total displayed. Say, you have numbers in cells A1 through A10 and want the total in A11..in the A11 cell, you would put this:

=SUM(A1:A10)

Hope that helps