Thread: setup an expense worksheet, but can't get all columns to sum properly.

Hi,

I apologize for such a beginner's question. I did try to find the answer on my own.

I have setup an expense worksheet. The columns are as follows:

Date....Check No....Amount Ck....Fuel....Fertilizer....FarmPhones....Parts...etc.
1/5/08.....32.......... $75.00..................$75.00


What I want is all of the columns to sum up a running total. So at any given time I can see how much has been spent for the items in the columns. I tried to set it up, but the only column that totals consistently is the "Amount" column. The others do not. Each time I insert a new row all of the columns except the "Amount" column only total to the previous row. Let's say the Fertilizer column is column E and I have 10 rows of data. When I add row 11 and make a new entry under "Fertilizer" it only sums through row 10. I then go to the formula window and change =sum(E3:E10) to =sum(E3:E11) then the column totals.

Can someone please help me.

Thanks,

Elizbeth

What cell or row are you currently putting your total into? If it is on another sheet then you can use the following formula to solve the problem (assuming that there isn't any data below the table you provided)

=SUM(Sheet1!E:E)

Another option would be to insert the row just above what your current range is. For example, if your formula is currently calculating =SUM(E3:E10), then you can insert a row before row 10 to put in your new entry, this will then automatically adjust your formula to =SUM(E3:E11).

Another option would be to put the formula in say E150, or somewhere down the page, and then hide, or group the unused rows so that they aren't visible if you don't want them to be. Your formula would be =SUM(E3:E150), but you could hide the unused rows until you fill them in and adjust the hidden or grouped cells accordingly.

Hope that helps.