I know I can add cells from multiple sheets with the following:
Sheet1:Sheet4!A2

But what if my sheet names have spaces in them? When I add the apostrophe
around the sheet name, I get a #Name$ error.

Thanks!

should be like this

=sum('Sheet 1:Sheet 2'!A2)

--


Gary

"Steph" wrote in message
...
I know I can add cells from multiple sheets with the following:
Sheet1:Sheet4!A2

But what if my sheet names have spaces in them? When I add the apostrophe
around the sheet name, I get a #Name$ error.

Thanks!

Try putting an underscore in the space Sheet_1

Like this

=SUM('Sheet1:Sheet 3'!A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steph" wrote in message
...
I know I can add cells from multiple sheets with the following:
Sheet1:Sheet4!A2

But what if my sheet names have spaces in them? When I add the apostrophe
around the sheet name, I get a #Name$ error.

Thanks!