Pete UK previous solution can't get it to work

[Diddy]

Hi,

What am i doing wrong?
I tried to use the formula =start:end!A1 to sum all A1 in sheets encompassed
by "start" and "end" sheets. Seemed a nifty solution in the following thread
(http://www.microsoft.com/office/com...&p=1&tid=4f20113f-eb61-4226-a7ab-1ceff3a2b8ca)

I don't know what I'm doing wrong but I get a #REF! error message.

Help!

 

[Mike H]

Try

=SUM(Start:end!A1)

Mike

 

[Pete_UK]

You must ensure that the summary sheet (the one with the formula in)
is not included between the sheets start and end - it must be outside
the "sandwich". Also, ensure that your sheet names do not have spaces
at the ends on the sheet tab.

Hope this helps.

Pete

 

[Diddy]

Thank you Mike!

Also need to try Brain Switch ON

 

[Pete_UK]

Thanks, Mike - have just checked back and realised I missed out the
SUM part in my rush to post before lunch.

Pete

 

[Diddy]

Thanks Pete,

That's a really handy thing to be able to do

 

[Pete_UK]

You're welcome, Deirdre.

Pete

 

[Mike H]

Your welcome

Thank you Mike!

Also need to try Brain Switch ON