=sum(cell reference-other cell reference)

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?

---

Thanks Both!

Or i've used the 'copy' and 'paste special' to use sums in different files

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.

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?