Countif on closed workbook data

[chris0b]

Hi all,
I have been trying to work out how to amend a COUNTIF formula to work on data in a closed workbook but not been very successful - this is a bit beyond my Excel capability!
I saw on a few posts where people had amended their COUNTIF to COUNT(IF( but I couldn't get this to work

I have several different versions of this formula looking up different codes but this is the easiest/shortest one so if I can work out what to change on this one I might be able to do the others

This is the original formula, if anybody can tell me how to edit it to work on a closed workbook that would be amazing
=IF(COUNTIF($AB$1:$AB$2,O24)=1,IF(COUNTIF('\filepath\[ORP.xlsx]ORP'!$H$8:$H$358,LEFT(N24,3))=1,TRUE,FALSE),TRUE)

 

[Fluff]

Hi & welcome to MrExcel.
You cannot use countif(s) on a closed workbook, try

=IF(COUNTIF($AB$1:$AB$2,O24)=1,IF(sumproduct(--('\filepath\[ORP.xlsx]ORP'!$H$8:$H$358=LEFT(N24,3)))=1,TRUE,FALSE),TRUE)