3D Sum
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! |
3D Sum
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! |
3D Sum
Try putting an underscore in the space Sheet_1
|
3D Sum
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! |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com