COUNTIF & SUMIF to a closed workbook

[warrell]

I'm really hoping someone can help. I have tried the general solutions a google turns up with no joy. Using these calculations return the VALUE error as the source workbook is closed. Could someone take a look at these and convert them so they work when the workbook is closed.

=COUNTIF('/Users/Downloads/[PT Delivery League Table.xlsx]Jan'!D5:D2004,"*") - Intention is to count all cells containing a name
=COUNTIF('/Users/Downloads/[PT Delivery League Table.xlsx]Jan'!F5:F2004,"Platinum") - Intention is to count all cells containing platinum
=SUMIF('/Users/Downloads/[PT Delivery League Table.xlsx]Jan'!G5:G2004,">0") - Intention is to add up all values greater than 0
=COUNTIFS('/Users/Downloads/[PT Delivery League Table.xlsx]Jan'!F5:F2004,"Platinum",'/Users/Downloads/[PT Delivery League Table.xlsx]Jan'!I5:I2004,">=1") - Intention is to count all Platinum with 100% or more
=AVERAGEIF('/Users/Downloads/[PT Delivery League Table.xlsx]Jan'!H5:H2004,">=0") - Intention is to average all numbers greater than 0

 

[horseyride]

see https://www.mrexcel.com/forum/excel-questions/399905-sumif-external-workbooks.html