| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looking for a solution | Excel Worksheet Functions | |||
| My solution | Excel Discussion (Misc queries) | |||
| AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS | Excel Worksheet Functions | |||
| Saving worksheet so that merge cells work in previous versions | Excel Worksheet Functions | |||
| How do I get hyperlinks, from previous version of excel, to work . | Excel Discussion (Misc queries) | |||
Linear Mode
