| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function THat wIll Add COntents Acorss Worksheets
In cell A5on Sheet1, place a formula or function that will add the contents of cell Z100 on all the sheets. How?  -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536268 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function THat wIll Add COntents Acorss Worksheets
Hi!
One way: Insert a blank worksheet and move it so that it is the first tab** and name it START. Insert another blank worksheet and move it so that it is the last tab and name it END. Then your formula would be: =SUM(Start:End!Z100) Any sheet that's inserted or moved and is between START and END will be included in the formula. If your formula is on Sheet1 and you don't want Sheet1 to be included in this calculation then move the START sheet to the immediate right of sheet1. (so that it's the 2nd tab and Sheet1 is the 1st tab). Biff "Triptanes" wrote in message ... In cell A5on Sheet1, place a formula or function that will add the contents of cell Z100 on all the sheets. How? -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536268 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function THat wIll Add COntents Acorss Worksheets
Thank you very much sir, you are magnanimous! -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536268 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function THat wIll Add COntents Acorss Worksheets
You're welcome!
Biff "Triptanes" wrote in message ... Thank you very much sir, you are magnanimous! -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536268 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| What worksheet function will formatlessly copy cell contents? | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
Linear Mode
