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
|