Help with Openoffice please

[charliecat]

I had this issue with Microsoft office too, please help.
When I sell on ebay I download the sales.
If I have sold 2 of something or 3 of something, it says I have in a seperate column. But it will only have the cost of one in the COST column. So if its 99p it will only have 99p, not 2.97, if i have sold 3.
I am SURE there must be a way to get it to take into consideration the quanitity column. But I have NO IDEA what im doing. Please help.
Really basic walkthrough required.

You need to have a "total" column which will contain a formula

if your quantity column is E and your cost column is F the formula would be

=E1*F1

then you copy the formula all the way down your "total" column using Edit > Fill > Down

Right thank you...chances are I will be back saying, sorry didnt get that. Thank you again...will go try...

good luck

ok, its L and M, i am putting the box(where i would like the total just under M its letting me put in the details L2*M2 but when i go to edit, fill, the down word is not pressable, you know you can see it but its grey.
What am I doing wrong?
Told ya id be back Sorry

Have you highlighted the cells underneath the cell with the formula in it?

Hmm, i ve tried and it said name? I have put the formula up where it says E=

Have you made column N your "Total" column?

You don't need to type the formula in the bar at the top: type it directly into the cell

If you are on row 10 type in exactly this:

=L10*M10

and it will give you the total

If the fill function isn't working, you can copy and paste the formula into the cells below (although that is more time consuming)

Right got the first one done. Why isnt the fill working? Where should I have the box highlighting beore I got to edit fill? I am very grateful for your help BTW

if you click on the cell with the formula in it, then drag your mouse down to highlight all the cells in that column underneath the formula, you should be able to use the Fill Down option - I'm not sure why it isn't working without being able to see what you're seeing iyswim

iT WONT LET ME DRAG IT WILL IF ITS SAYING 99 P, BUT NOT WITH THE FORMULA ARGH

click away from the cell with the formula in, then click back on it once and drag - it won't let you drag if you are editing the cell

starting to want a fag..stopped smoking 3 years ago LOL right will try that....back in a mo

lol!

you'll get there, don't worry

oh my god, I dont know what ive done now. I have managed to get it to do something , in all the totals but its not adding up lol...will go investigate see what it has added up
Duh and thank you for your patience!

oh oh nearly, its just one line out...that must be fxable, i have deleted and a going to try again.oh oh excited

Quantity Sale Price Total Postage & Packing Insurance Total Price
1 £0.99 £0.99 £1.50 £0.00 £2.49
1 £5.19 £5.19 £0.31 £0.00 £5.50
1 £0.25 £0.25 £0.31 £0.00 £ 0.56
2 £1.98 £3.96 £2.75 £0.00 £4.73
1 £0.99 £0.99
1 £0.99 £0.99
5 £4.95 £24.75 £6.01 £0.0 0 £10.96
1 £0.99 £0.99
4 £0.99 £3.96
1 £0.75 £0.75 £0.31 £0.00 £1.06
1 £0.75 £0.75 £0.00 £ 0.00 £0.75
1 £0.99 £0.99 £0.31 £0.00 £1.30
1 £1.00 £1.00 £0.31 £0.00 £1.31
2 £0.99 £1.98 £1.48 £0 .00 £3.46
1 £0.99 £0.99 £0.31 £0.00 £1.30
1 £0.75 £0.75 £0.31 £0.00 £1.06
1 £9.99 £9.99 £1.50 £0. 00 £11.49

you have done it!

arse that looked ok before i posted. Now i have a problem...another one...its added up something once then again or something....is there a formula to stop that...sorry phone rang.

Nearly! Can you see the 4.95 one? well that what actually 5x99ps adding up to 4.95, its understandable times it by the 5 making 24poins something but including postage it was only te pounds something....get me? Any ideas what to put in it to stop that?

gtg school run will retrun later. Thank You MUCHly for your help. Serioulsy apprecaitedOpps at spelling

OK what you need to do is this

in yoru "Total Price" column you need to enter this formula

=C1+D1+E1

or

=SUM(C1:E1)

either will do the same thing - it will add the total, P&P and Insurance to give you your proper total price

PS substitute whichever row you are on for the "1" in that formula

HTH

Couldnt face this again last night Gonna tidy up, make a cuppa coffeee and try again.....lol

This isnt funny anymore.
Cant get the totals to match and i cant see why