Excel formula help

[parklifeclothes]

If I had any hair it would be long gone, but natures already taken care of that issue!!

On the real issue, I am using excel to keep track of our stock and have built formulas to calculate totals (cost and retail) on all the sheets i.e Bench, Diesel, Kickers, now what I want to do is for these sum totals to be automatically transfered to another sheet called Totals so as I have an always upto date figure of stock holding and total selling prices.

I have searched high and low on how to do this but with little success so far, any help very much appreciated

[Duncan Rounding]

The simplest way isto type '=' in the cell on the worksheet you want the answer to be then just navigate to the worksheet and cell that you want. You can then press '+' and again navigate to the worksheet and cell you want to add to the first one and so on.

eg:
=Sheet2!A1+Sheet3!A1

[parklifeclothes]

You star, it's taken me weeks to get nowhere and in minutes I've got the answer.

Millions of thanks


Darron