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

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

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