Help with countifs on closed workbook

[RIDINGO]

Hi all

I was hoping someone would be able to help me with using sumproduct as a replacement for countifs on closed workbooks. I've been able to get it to work for when I have countif, but seem to be making a silly mistake with countifs.

My original formula is:
=(COUNTIFS('[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$F$4:$F$264,"<>",'[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$M$4:$M$264,">-1"))/$C4

Is there a way to do this with sumproduct?

Thank you so much for any help!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=sumproduct(('[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$F$4:$F$264<>"")*('[Y8 Tracking Spreadsheet 2021-2022 .xlsx]Raw Data'!$M$4:$M$264>-1))/$C4

 

[RIDINGO]

That's amazing, thank you so much!

Sorry for the follow up question, but is there a way to get this to ignore any N/As in the data?

Thanks again!

 

[Fluff]

You would be better off removing the errors in cells you are looking up.