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