Hi,
I am using sumproduct across two different workbooks - (1 will be closed when the SUMPRODUCT one is open) I am using it as a nested SUMIF so I am adding the results in column AF based on names in Column F - this is the formula
=SUMPRODUCT((--('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$F$7:$F$8000="Dog")*('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$AF$7:$AF$8000)))+SUMPRODUCT((--('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$F$7:$F$8000="Cat")*('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$AF$7:$AF$8000)))+SUMPRODUCT((--('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$F$7:$F$8000="Hamster")*('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$AF$7:$AF$8000)))+SUMPRODUCT((--('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$F$7:$F$8000="Rabbit")*('[DLS Error Report 2018 MASTER.xlsx]Error Summary By Branch'!$AF$7:$AF$8000)))
the formula works as expected except when the DLS report is closed - it still works but gives a slightly different result - the same formula summing a different column works fine whether the DLS report is open or closed.
I can't work out why this is, any ideas?
Thanks
Jen
Bookmarks