Pete UK previous solution can't get it to work
 

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/comm...b-1ceff3a2b8ca)

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

Help!

--
Deirdre

Pete UK previous solution can't get it to work
 

Try

=SUM(Start:end!A1)

Mike

"Diddy" wrote:

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/comm...b-1ceff3a2b8ca)

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

Help!

--
Deirdre

Pete UK previous solution can't get it to work
 

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

On Aug 4, 12:43*pm, Diddy wrote:
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/comm....mspx?&lang=en....)

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

Help!

--
Deirdre

Pete UK previous solution can't get it to work
 

Thank you Mike! :-)

Also need to try Brain Switch ON
--
Deirdre


"Mike H" wrote:

Try

=SUM(Start:end!A1)

Mike

"Diddy" wrote:

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/comm...b-1ceff3a2b8ca)

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

Help!

--
Deirdre

Pete UK previous solution can't get it to work
 

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

Pete

On Aug 4, 12:52*pm, Mike H wrote:
Try

=SUM(Start:end!A1)

Mike



"Diddy" wrote:
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/comm....mspx?&lang=en...)

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

Help!

--
Deirdre- Hide quoted text -

- Show quoted text -

Pete UK previous solution can't get it to work
 

Thanks Pete,

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


"Pete_UK" wrote:

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

On Aug 4, 12:43 pm, Diddy wrote:
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/comm....mspx?&lang=en....)

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

Help!

--
Deirdre

Pete UK previous solution can't get it to work
 

You're welcome, Deirdre.

Pete

On Aug 4, 1:03*pm, Diddy wrote:
Thanks Pete,

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

Pete UK previous solution can't get it to work
 

Your welcome

"Diddy" wrote:

Thank you Mike! :-)

Also need to try Brain Switch ON
--
Deirdre


"Mike H" wrote:

Try

=SUM(Start:end!A1)

Mike

"Diddy" wrote:

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/comm...b-1ceff3a2b8ca)

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

Help!

--
Deirdre