Veronica,

Try something like

=SUM('FirstSheet:LastSheet'!B10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"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