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? :confused: -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536268 |
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? :confused: -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536268 |
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 |
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 |
All times are GMT +1. The time now is 06:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com