spreadsheets

plumber_carl

I need a basic spreadsheet to calculate some figures, i require one which is simple to use as not so famaliar with spreadsheets.
Is such available for free/download?
Any advice greatly appreciated, thanks in advance.

Lokolo

Open Office has a spreadsheet bit of software with it.

plumber_carl

thanks lokolo i seem to have open office,, and just spent a hour or so trying to get it to calculate a few Figures but it will not add them up so i gave up and come on here,, it would be ideal as i only need the basics

Mrs_Arcanum

There is usually a quick formula button (bit like a sideways M) which will add up a column of figures for you.

plumber_carl

been trying that side says m,,,, it asks for a formula then it works but then when i try again it will not add it up second time??

Joe_Bloggs

This is an openoffice.org tutorial that starts off with summation.
J_B.

Lil306

Carl, what are you trying to do exactly?
Tell us which cells contain the values and we'll amend

Or alternatively, upload a dummy document (a replica of the one you have but with false values) to google documents and we can actually show you what you need to enter

boxst

You probably need to say =sum(cell1:cell2) or something similiar?

What are you trying to do?

STeve

patman99

First-off get shot of Openoffice and replace with Libreoffice.

jimmo

What is Openoffice?
What is Libreoffice?
I don't know.
In my little world I am a legend in my own lunchtime on spreadsheets but I don't even understand macros. However, I am pretty good at using formulas and can make spreadsheets sing and dance to my satisfaction.
There could be a simple solution to your problem but, as things stand, we really don't know what your problem is.
Do you care to share a bit more detail about what you are trying to achieve?

paddyrg

Dear OP, all spreadsheets will have a little learning curve. Thet are like electronic squared paper, you can do stuff with them, but if it is more than just drawing, you need to know what you are trying to do, and think methodically.

Each cell on a spreadsheet is like a tiny powerful calculator. It can do a simple sum (try typing "= 2 + 2" (without quotes) into a cell, it will display "4"), or a more complex one ("= C5 + 2" will add 2 to whatever is displayed in cell C5, and display it in whichever cell you entered the formula in). Form thereon, it is more of the same, but with more complicated formulas for more complicated things.

I suggest you take a beginners course, or at least follow a good tutorial, as all spreadsheets work more or less the same, and once you master working with them you have a world of power at your fingertips - but you will need a little upfront effort!