Thank you, thank you, thank you. That worked-once i got the spacing correct!

"Bernard Liengme" wrote:

This worked for me: =SUM('Sheet1:Sheet1 (3)'!A1)
Note the spacing in "Sheet1 (3)" --- no space before the 1 but one space
before the (
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kcir" wrote in message
...
I am using Excel 2003. I have three different sheets-Sheet 1 through Sheet
1
(3). what i am trying to do is to add a particular cell from all 3
sheets.
I tried using this formula after using the help featu
=SUM(Sheet1:Sheet 1(3)!D34)

that doesnt seem to work. I even tried putting the sheets in single
quote-still didnt work. What did i do wrong?