Indirect?
I have the following in a workbook "ABC.xls" =ROUNDDOWN(SUM(SUMIF($B$6:$B$69,{"EE3","EE6","HE3" ,"HE6", "OE3","OE6","OHE3","OHE6"},$E$6:$E$69)),-2) I would like to place the formula in another workbook "DEF.xls" but maintaining the same references in "ABC.xls". I have used indirect on its own in the past to reference cells in other workbooks but I cannot think how to apply it in this case. Grateful for any advice. -- Robert |
Indirect?
Isn't it just
=ROUNDDOWN(SUM(SUMIF([ABC.xls]Sheet1!$B$6:$B$69,{"EE3","EE6","HE3","HE6","OE3"," OE6","OHE3","OHE6"},([ABC.xls]Sheet1$E$6:$E$69)),-2) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Robert" wrote in message ... I have the following in a workbook "ABC.xls" =ROUNDDOWN(SUM(SUMIF($B$6:$B$69,{"EE3","EE6","HE3" ,"HE6", "OE3","OE6","OHE3","OHE6"},$E$6:$E$69)),-2) I would like to place the formula in another workbook "DEF.xls" but maintaining the same references in "ABC.xls". I have used indirect on its own in the past to reference cells in other workbooks but I cannot think how to apply it in this case. Grateful for any advice. -- Robert |
Indirect?
In message , Bob Phillips
writes Isn't it just =ROUNDDOWN(SUM(SUMIF([ABC.xls]Sheet1!$B$6:$B$69,{"EE3","EE6","HE3","HE6" ,"OE3","OE6","OHE3","OHE6"},([ABC.xls]Sheet1$E$6:$E$69)),-2) With a tiny bit of tweaking it is! Many thanks -- Robert |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com