any excel experts

[marky b]

im trying to set up a spreadsheet that will enable me to add our spending on a daily basis so i need a figure at the top. ie what is in the bank and as i include items bought it decreases the amount.

I also need to be able to add amounts when wages go in.
it cant be that complicated but its mashing my head, help please.

[mfne]

hi marky b. look for the Auto Sum icon or type Auto Sum into the help window. this will tell you how to do calculations on the excell spreadsheet.

[marky b]

cheers, i worked out how to add numbers but not subtract them.

[Welsh Boy]

marky b

If you are trying to add a column of numerical figures then the formula is:

=SUM(E2:E38)

IF you entered this formula in cell E40 or on the top bar then it would total the numeric values and put the total in cell E40.

You can use any cell you wish this is just an example,hope this may help.Tony

[RisingTide]

Hi Marky,
I just replied but it got swallowed - I'll try again!
If you haven't tried formulae in excel then that might be the thing to try. Here is a simple example of what I mean and if it helps then great ...
Use col A for months of the year starting at cell A2 and put amounts in starting at cell B2. Into cell C1 put a starting amount. Now to get a decreasing balance input this formula into cell C2:
=C1-B2
You can then copy this down to other cells and it will increment the row numbers.

Kenny

[RisingTide]

Now lets say you want to have a constant amount taken off each month. Plonk that in cell D1 and then refer to it in your formula as D$1. The dollar sign holds the row number constant in all copies of the formula. So the content of cell C2 then becomes =C1-B2-D$1 and when copied into cell C3 it becomes =C2-B3-D$1 without you having to edit it manually.
Hope that helps too
Kenny

[marky b]

right cheers guys see ya in a while.[:D]

[kallis3]

It's about as understandable as Swahili to me!

Me and figures and spreadsheets are mortal enemies!

[Julie]

Looks like Rising Tide has sorted it for you....if you need more help ask, I'm pretty nifty on spreadsheets [:D]

Lesley tutors in IT so she'll help too xx

[Julie]

I'm not on Lesley's scale Helen....but I use spreadsheets so much for work, kinda get used to them.

[Skippy]

I like using spreadsheets and I've done intermediate and advanced Excel although I've forgotten a lot of if as I don't have to use the advanced stuff for work.

Unfortunately I'm rubbish at explaining things, which is why I haven't tried to help!

[Julie]

Skip you're spot on....I've done advanced excel, access etc. I use excel daily so can explain it, but access??? Well I can do queries and run reports but thats it..I don't use it daily.

I'm good at word though[:D]

[Julie]

I'll make a note of that ladyH! [:D] one thing I hate is mailmerge[}:)]

[kallis3]

Scary!!!!!!!!!!

[Shining]

Always use the mailmerge wizard you can't go wrong I promise tis so simple!

Did you get your spreadsheet sorted Marky B? If not let me know and I'll try and help, I have lots of workbooks here for Office 2003 (assuming you have that)? as they're out of date for us at college now so just let me know and I'll get one over to you, you won't have the files but can create your own to practice.

I think with spreadsheets BODMAS rules come into place - brackets etc., also relative an absolute formulas need to be used and once set up can be used for years.