Hi,
I have a formula using an Indirect function which normally works. However in this instance it won't accept the Named Range. The cell is looking in a number of workbooks and summing cells that meet two conditions. I have attached the workbook, any support here is greatly appreciated. The Cell with the formula is =IF(OR($A22="",C$21=""),"",SUMPRODUCT(SUMIF(INDIRECT("'"&_Payrun&"'!$E$7:$AE$7"),C$21,INDIRECT("'"&_Payrun&"'!R[0]C5:R[0]C31",FALSE)))). The Cell is returning #NAME.
Michael
Bookmarks