dynamic 3d sum
Hi, I have a book with 13 sheets named 1 to 12 and Total on the 13th (Total) there are formulas like: =sum('1:12'!A1) Can i sum sheets 1 to X depending on another cell or name ? avner -- Avner ------------------------------------------------------------------------ Avner's Profile: http://www.excelforum.com/member.php...fo&userid=5078 View this thread: http://www.excelforum.com/showthread...hreadid=274189 |
Try the following... =SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:"&C 1))&"'!A1"),"<")) ...where C1 contains "x". Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=274189 |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com