Is this what you need?
=SUM(Sheet1:Sheet3!C1)
If sheet names have spaces use =SUM('sheet x:sheet y'!C1)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul Hargreaves" <Paul wrote in
message ...
How to Use the sum function in a 3 dimension environment in Microsoft
Excel?
Need a detailed description for a research paper I am doing, ASAP!!!!