Adding a value to a specific cell

[tkadz]

Hi all, not sure where to post this as I'm new to open office and generally suck at spread sheets. So apologies if this is in the wrong place.

I have set up a spread sheet (image included) that has several sections/ tables, that shows a monetary value. I want to be able to put a tick in each cell, if i sell and item. And for the spread sheet to automatically tot up sales, depending on which item is sold.

For example. If i put a tick in the section marked stickers. I would like the total box to increase by 30p. But if I tick the poster box, the total will add on £10.

Does this makes sense? Is this even possible?

cheers in advance,

Kadz

[RusselB]

Welcome to the Forums.
To start with, since you are using a spreadsheet, you should realize that the spreadsheet part of OpenOffice is called Calc, thus you should've posted in the Calc section.
I strongly suggest that you do not use a Check in the boxes, as putting numbers into them is a lot easier and gives you a lot more options later on.
For example, if you have 2 comics, instead of having to put in two checkmarks (which would limit you to 24 entries), you could just enter the number 2.. then you can easily get Calc to figure $2 * 2 items (I don't have the pound symbol for the currency you used available)... rather than have Calc count the number of checkmarks and then do the math.
It's a small difference to Calc, but for you to enter the information will be a lot easier.

[tkadz]

Thank you,

im guessing going to the Calc part of this forum, i will be able to find the right tutorials to learn to do this?

[robleyd]

Perhaps start with:
[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
[Tutorial] Absolute, relative and mixed references

There are more topics in the Calc Tutorials section of the forum.