From the summary sheet type

=SUM(


then using the mouse select the B10 on the first sheet, hold down shift key
and select the last sheet tab and press enter. Excel will help you by
enclosing with a parenthesis. it will look like

=SUM(Sheet1:Sheet10!B10)


where Sheet1 and Sheet10 will be replaced with your real names



--
Regards,

Peo Sjoblom



"Veronica_s" wrote in message
...
I have 35 worksheets and would like to be able to add up the dollar figure
that is on my B10 cell. I've created a summary worksheet and just can't
seem
to get my formula correct. I was using this: =Sum(worksheetname!B10, etc,
etc,

Can someone please help! I would surely appreciate it. I am working with a
deadline. Thanks!!!!!

P.S. Working w. excel 2007