Can somebody help with a spreadsheet? [Problem solved]

NewKidOldKid · Apr 3, 2011

I've been using a spreadsheet to track business expenses. I downloaded the spreadsheet from a website because I'm clueless on how to set one up. For some reason, a few of the fields don't work. I tried fixing it and made it worse and now the numbers don't add up automatically like they did before. Could somebody PLEASE take a look at it (I'll be happy to send it via email) and fix the problem? It shouldn't take more than a minute or two for somebody who understand how this works! I've been trying to figure out for the past hour or so and it's driving me crazy!

alleycat · Apr 3, 2011

Some of the cells may be protected.

Is it an Excel file?

NewKidOldKid · Apr 3, 2011

Yeah, it's an excel file. It's basically a long list of days/months, with columns where you can enter different expenses. Then it adds up the expenses for each column and gives you the total for the month. March worked fine. April's not working.

alleycat · Apr 3, 2011

I'll take a look at it. You probably have something like H22 = Sum of H3 to H22 and it's driving it crazy.

I'll send you my e-mail address by PM. You can explain which cells aren't working.

Why don't you just copy the March worksheet (delete the extra day) and renamed it April?

NewKidOldKid · Apr 3, 2011

alleycat said:
I'll take a look at it. You probably have something like H22 = Sum of H3 to H22 and it's driving it crazy.

I'll send you my e-mail address by PM. You can explain which cells aren't working.

Why don't you just copy the March worksheet (delete the extra day) and renamed it April?

Thanks so much. Email sent.

You'll see when you open it that it's a single spreadsheet that contains the whole year, so can't copy/rename.

alleycat · Apr 3, 2011

Okay. I'll take a look. I use Excel for a number of things, so I might be able to help.

alleycat · Apr 3, 2011

The first problem was easy enough to fix. Now to look at the second problem.

NewKidOldKid · Apr 3, 2011

alleycat said:
The first problem was easy enough to fix. Now to look at the second problem.

I'm impressed.
Excel spreadsheets seem so foreign to me. I need to eventually sit down and figure out how they work.

alleycat · Apr 3, 2011

Okay, I fixed the SUM errors in B column for March and April. I also found a SUM error in C column for April. I didn't see any other errors offhand, but I didn't check every column. If you see any problems with any of the other column totals when you're filling them out, you'll need to make sure all the column SUMs use the same range of rows; for example: =SUM(B98:B137), =SUM(C98:C137), and so on. Make sense?

I didn't have any problem changing the dates. I changed a few in May. You just need to select the cells and then edit the last digit from a 0 to a 1 in the top edit box.

I'm sending the file back to you, renamed (you can rename it once you see it's working).

NewKidOldKid · Apr 3, 2011

Thanks! You rock. It's been driving me crazy for hours! Like I said, I either need to learn how to work with excel or I need to find another method to keep track of things.

alleycat · Apr 3, 2011

Excel worksheets can get complex if you take data from this cell, and that cell, and a cell on another worksheet, etc., but your worksheet is pretty straightforward. It's just adding up (SUM) the rows for each column, and adding up the value of the columns to the right. Just be sure all the ranges (whether columns or rows) are the same; that is, the SUM for the B column should just contain value in the B column and within the proper number of rows.

The grand total for March worked because it used the SUM of the last column (N column, if I recall correctly). It didn't sum the rows, so even though there was an error in the total for the B column, the grand total SUM didn't use that value.

NewKidOldKid · Apr 3, 2011

Thanks! It's a simple spreadsheet but works really well for me, so I didn't want to go hunting for something else.

Can somebody help with a spreadsheet? [Problem solved]

NewKidOldKid

diplomat

alleycat

Still around

NewKidOldKid

diplomat

alleycat

Still around

NewKidOldKid

diplomat

alleycat

Still around

alleycat

Still around

NewKidOldKid

diplomat

alleycat

Still around

NewKidOldKid

diplomat

alleycat

Still around

NewKidOldKid

diplomat