Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
|
Trying to devise something that shows my current stock, one one sheet, sales on another, cost of sales on another, and balances on the last sheet.
On the last sheet, can I;
Somehow use a Total Sales figure from sheet 2 and minus it with the total cost of sales on sheet 3?
Or can sums only be done on the same sheet?
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
You can do them on different sheets.
Just start in the cell where you want the sum doing and press "=", then just click the sheet, cell, etc. then "+" or "-" or whatever. Hope that explains it.
|
Simon
Member
Registered: 24th Apr 03
Location: Oxfordshire
User status: Offline
|
Or i've used the 'copy' and 'paste special' to use sums in different files
|
Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
|
Thanks Both!
|
Gary
Premium Member
Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
|
quote:
Originally posted by Whittie
Trying to devise something that shows my current stock, one one sheet, sales on another, cost of sales on another, and balances on the last sheet.
On the last sheet, can I;
Somehow use a Total Sales figure from sheet 2 and minus it with the total cost of sales on sheet 3?
Or can sums only be done on the same sheet?
Your useless. Email it over.
|
dan_m1les
Member
Registered: 8th May 06
Location: Burnham, Buckinghamshire
User status: Offline
|
=sum(cell reference-other cell reference)
|
