Hi Veronica,

I'm not sure if this will work in 2007 but if you can try this in your
summary sheet

=SUM(Sheet2:Sheet35!B10)

Replace Sheet2 with your first worksheet name that you want to sum and
Sheet35 with your last worksheet name...

Gav.

"Veronica_s" wrote:

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