Indirect?

[Robert]

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.

 

[Bob Phillips]

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]

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