COUNTIFS and SUMIFS and AVERAGEIFS workbook linking

Hi

I hope someone can help.

I'm trying to link to external workbook and having issues with my formula. I know I can't link with Countifs, so have tried using SUM(IF( and SUMPRODUCT but I still can get the functions to work.

The formulas I'm using are as follows:

{=IFERROR(COUNTIFS('S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$N$2:$N$3000,"=Inbound Email",'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$S$2:$S$3000,"=N", 'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$B$2:$B$3000,">="&EDATE(TODAY(),-12), 'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$B$2:$B$3000,"<="&TODAY()),0)}

{=IFERROR(AVERAGEIFS('S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$Q$2:$Q$3000,'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$N$2:$N$3000,"=Inbound Email",'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$S$2:$S$3000,"=N",'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$U$2:$U$3000,"=Y",'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$B$2:$B$3000,">="&EDATE(TODAY(),-12), 'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$B$2:$B$3000,"<="&TODAY()),0)}

{=IFERROR(SUMIFS('S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$Q$2:$Q$3000,'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$N$2:$N$3000,"=Inbound Email",'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$S$2:$S$3000,"=N", 'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$U$2:$U$3000,"=Y",'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$B$2:$B$3000,">="&EDATE(TODAY(),-12), 'S:\Company Admin\Sales & Marketing\[Master Data Sheet.xlsx]Data'!$B$2:$B$3000,"<="&TODAY()),0)}

Any help appreciated.

Thanks

Hi Ace_XL

Thanks for this.

Tried the change but no luck with linking to the closed workbook, obviously this works when the external workbook is open, (my original formulas worked fine in this senario) but doesn't solve the problem as the values need to be pulled for a closed worksheet.