creating formulas
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?
|