Excel Formulas - Please help...

[AnnieBeansMum]

**Disclaimer: I am a complete nerd control freak and I need help formatting Excel to create a budget.

OK...so DH and I have just moved into our new place (after emigrating from the UK) and because we have no concept as to costs here in Canada, I have set-up a spreadsheet tracking our monthly expenses for September, October and November.

I have a sheet for each month and on the bottom of the final sheet, I have managed to total the costs for Sept+Oct+Nov (=SUM(September:November!Q17) which I will then average to determine monthly outgoings.

So the bottom of the November sheet says:

D..................E
20 September.......$
21 October.........$
22 November........$
23 TOTAL...........$3,618.46

But I cannot for the life of me figure out how to import the balance from sheet one into E20, sheet two into E21 and sheet three into E22. Can anyone help???

Thanks...

just do an = in teh cell you want the figure, then go to the figure you wnat to insert and click on it

That has created this formula =September!Q17 but the cell looks like this ####### ???????? What am I doing wrong???

in E20 just + or = the total off the Sept sheet.

ie if the Sept total is in cell x99, then go =
[hop to X99 on Sept sheet] X99
return

Am I missin something or is are you trying something a bit more complicated?

is the column too narrow for the amount of digits?

Cell isn't wide enough to show the number, just drag the column wider

you need to expand the column width until you can read the number

ah I think that is the cell format then - right click and go to format cell and make sure that it is "general" or "number".... on both the destination cell and the source one to be on the safe side

Could be number formatting. That is usually what you get if the column isn't wide enough for the amount of digits, so either widen the column or change the number formatting.

Does that work?

OH. MY. GOD. I am a complete and total dunce. I have been using Excel for years and I know what ###### in a cell mean.

:::::flogs self with a trout and sheepishly backs away:::::

Thanks everyone

Yep, column too narrow imo. Double click on the right edge of the column header to resize the column for all cells.

And this isn't in chat so will stay here for ever.

I think you'll have to change your username.

You plonker!!

I love the fact that all the excel geeks on here pounced as soon as this appeared in active convos and we're probably still rubbing our hands in glee at being able to answer the question

"My name is megonthemoon and I'm addicted to Excel"

stretch the cell me love [smiloe]

self confessed budget obsessed excel nerd is i

I feel slightly ashamed that I even clicked on the thread thinking 'ooohh, I wonder if I can answer this'

so am i actually ladybee - i think i will ask for my minimal input to be deleted.

Dammitt too late....ask me another one

My name is MarionCole and I love excel

I am so impressed that anyone makes monthly budgets on excel spreadsheets. We dream of that sort of stuff!

Lougle. I do not know how anyone can live without Excel. It's just not, well, right.

Don't worry, I have a new excel table I am setting up to keep track of my hours month to month at work - I will be over here soon with REAL hard questions

I have 4 thick books with excel formulas, tips and tricks, the list goes on...

ooh yes go on jamaisjedors, I'm bored and want to avoid ironing be useful.