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.

Hi charliecat

Can you post what you've got to show how the totals don't match?

Oh i love you...you are like my mumsnet angel...will try...

1 £0.99 £1.50 £0.00 £2.49
1 £5.19 £0.31 £0.00 £5.50
1 £0.25 £0.31 £0.00 £0.56
2 £1.98 £2.75 £ 0.00 £4.73
1 £0.99
1 £0.99
5 £4.95 £6.01 £0.00 £10.96
1 £0.99
4 £0.99
1 £0.75 £0.31 £0.00 £1.06
1 £0.75 £0.00 £0.00 £0.75
1 £0.99 £0.31 £0.00 £1.30
1 £1.00 £0.31 £0.00 £1 .31
2 £0.99 £1.48 £0.00 £3.46
1 £0.99 £0.31 £0.00 £1.30
1 £0.75 £0.31 £0.00 £1.06
1 £9.99 £1 .50 £0.00 £11.49
1 £0.75 £0.31 £0.00 £1.06
2 £0.75 £0.62 £0.00 £2.12
3 £0.99 £3.03 £0.00 £6.00
1 £0.75 £0.31 £0.00 £1.06
2 £0.50 £0.31 £0.00 £1.31
2 £0.99 £2.02 £0.00 £4.00
1 £1.75 £0.50 £0.00 £2.25
5 £6.47 £2.50 £0.00 £8.97
3 £0.99
2 £1.75
1 £1.75 £0.50 £0.00 £2.25
1 £1 .75 £0.50 £0.00 £2.25
1 £1.75 £0.50 £0.00 £2.25
1 £1.75 £0.50 £0.00 £2.25
1 £1.75 £0.50 £0.00 £2.25
1 £0.99 £0.99 £0.00 £1.98
2 £1.75 £0.70 £0.00 £4.20
2 £0.50 £0.62 £0.00 £1.12
1 £0.25
1 £0.25
1 £1.75 £0.50 £0.00 £2.25
1 £1.75 £2.25 £0.00 £4.00
1 £1.21 £0.31 £0.00 £1.52
2 £1.98 £0.31 £0.00 £2.29
1 £0.99
1 £0.99
2 £0.99 £1.48 £0.00 £3.46
1 £0.99 £0.31 £ 0.00 £1.30
2 £1.75 £0.70 £0.00 £4.20
1 £0.99 £0.31 £0.00 £1.30
1 £6.01 £1.50 £0.00 £7.51
1 £0 .99 £1.50 £0.00 £2.49
1 £2.99 £1.01 £0.00 £4.00
1 £0.74 £0.31 £0.00 £1.05
1 £0.69 £0.31 £0.00 £1.00
1 £2.99 £1.01 £0.00 £4.00
1 £5.50 £1.50 £0.00 £7.00
1 £2.99 £1.01 £0.00 £4.00
2 £2.99 £1.51 £0.00 £7.49
2 £0.99 £2.50 £0.00 £4.48
1 £0.99 £2.25 £0.00 £3.24
1 £2.99 £1.01 £0.00 £4. 00
2 £2.99 £1.51 £0.00 £7.49
1 £0.99 £0.99 £0.00 £1.98
2 £2.99 £1.51 £0.00 £7.49
1 £0.60 £0. 31 £0.00 £0.91
1 £0.75 £0.31 £0.00 £1.06
2 £0.99 £2.02 £0.00 £4.00
1 £0.99 £0.99 £0.00 £1.98
2 £0.50 £0.31 £0.00 £0.81
1 £0.25
1 £0.25
1 £2.99 £1.01 £0.00 £4.00
1 £0.99 £1.50 £0. 00 £2.49
1 £1.50 £1.50 £0.00 £3.00
1 £2.99 £1.01 £0.00 £4.00
1 £2.99 £1.01 £0.00 £4.00
1 £6.0 0 £2.50 £0.00 £8.50
1 £2.99 £1.01 £0.00 £4.00
1 £0.74 £0.31 £0.00 £1.05
1 £2.99 £1.01 £0.00 £ 4.00
3 £0.75 £0.71 £0.00 £2.96
1 £0.75 £0.31 £0.00 £1.06
2 £2.99 £1.51 £0.00 £7.49
2 £0.75 £ 2.50 £0.00 £4.00

£146.68 £75.25 £238.14

in the forth row can you see 2 x 1.98 plus 1.75 postage and its total was 4.73??!! Why is it not the right amount??

sorry, 2.75 postage...itd the imformation on the spreadsheet thats incorrect isnt it...And i dont know how to make it right...othr than manually going through the whole frigging lot

I would set my spreadsheet up like this

Description |Quantity | Sale Price | Total | Postage & Packing | Insurance | Total Price

blah blah blah | 2 | 0.99 | =(B2*C2) | 2.50 | 0.00 | =SUM(D2:F2)

then copy the formulae down the columns

ah I see

Try this formula in the total column then

not sure what your columns are exactly but say your quantity is in column B and your price is in column C

=(B2*C2)+D2+E2 (to add the P&P and Insurance)

not very elegant looking but it should give you the correct total, if I'm understanding how you've set your spreadsheet up correctly

Right that looks good. Maybe the issue is that I ddint set the spreadsheet up...when you download your stuff from ebay it....ta da..is all done for you. Except the adding......which SHOULD be simple...Im sure it is realy...now will go have a scratch at that now. Thank you again

Going to bury my head in it for a bit, at some stage it, before I have fiddled, it SOMEtimes adds up the quantitys, so 2 at 99p become 1.98, but sometimes it doesnt...so when i tell it to * the columns it muddles it up further.
Am going to go through the list. Put the right amounts in. And see where I end up..Cheers...Will be back!

Ah, it's always so much easier when it's something you've set up yourself I think, so I can see why this is being such a pain in the butt

good luck, I'll keep checking the thread

I could sort it out for you if you emailed the spreadsheet to me, would that be better?

I have done it..HUGE sigh.
THANK YOU... I would like to email the original to you, so you can see how it sometimes adds up the quantitys and sometimes doesntAnd when it does it will have 25p, 25p AND the total 50p in the same column adding to a quid...
Most irritating.
This is how I did it last year with office, having to go throught and manually do it Makes me so stressed
my email is [email protected] Not really..lol take out the LE and add il. I will then see if i can send it to you....more trauma LOL Thank you again

no probs, well done on sorting it out!

I have emailed you