Microsoft Excel

[phleb]

Need some help everyone, i have set up an invoice on excel, and where i have put in the sums, i want to subtract one from the other sum. I can do autosum to add them up, but when i come to subtract the one number from the list of numbers, i cant do it. I don't know how to :-( Any simple tips and advice gratefully appreciated.

[jim360]

It should be something like

"=A2-A3"

where obviously you should use the relevant cell numbers but the key point is to use the - symbol that's just next to the = on a keyboard.

[Old_Geezer]

:-)

Can't help thinking the problem has been described such that it reads simpler than it actually is.

[Retrochic]

if A9 is your total (A1toA8) and you want to subtract ie A5 then highlight B9 and insert value = A9- A5. This will give you the original sum (A1 to A8) minus whatever amount was in cell A5

[Mosaic]

Mine must be an antique veersion as it will only accept =SUM(A9-A5)

[tamborine]

Just bracket the figure you want to subtract, thus (1234)

[Retrochic]

tamborine that's not correct as when you bracket the number it turns it into a negative value which affects the result but not correctly ie 5+5+5=15 BUT 5+5+(-5) = 5. On reflection the easiest way is to delete the value from the cell and make note of the result. Hopefully the OP will come back on this one and let us know how they got on.

[ToraToraTora]

Say you have in cells A1-F1 the numbers 10,20,30,40,50,60 and you want to add then up but one of them needs to be subtracted, eg suppose the number in C, ie 30, needs to be subtracted then in the cell where you want this sum you put =SUM(A1-F1)-(2*C1), that will add them all up then take off C then take it off again, ie as if subtracting, that way the sum will work even if you insert new lines.

[factor-fiction]

Maybe I've misunderstood but some responses seem to make this seem more complicated than it really is.
Can you give an example please, phleb, of what you are trying to do. Include some numbers. Thanks

[overthetop]

Put a minus sign - in front of the number to be deducted?

[ToraToraTora]

it's clear to me, there is a list to add up, one of the numbers is listed as a positive but needs to be treated as a negative: "...I can do autosum to add them up, but when i come to subtract THE ONE NUMBER from the list of numbers,...". hence my answer above, phleb can you confirm you are now sorted.