I am trying to count all instances of picking pm from closed workbook named "hit report", sheet "staff database" columns E and X, I have tried the below but it's not working
=SUMPRODUCT(--('[Hit Report 27.xlsm]Staff Database'!$E$1:$E$2000="Picking"),--('[Hit Report 27.xlsm]Staff Database'!$X$1:$X$2000="PM"))
Using sum product as countifs formula didn't work in closed workbook. Can anyone help?
Bookmarks