Trying to Perform a Count of specific values across 3 ranges from another Google Sheets Doc.

Answered below.

CodePudding user response：

=iferror(index(query({IMPORTRANGE(Source!B2,"TESTING!A2:C")},"select count(Col1) where Col1 = 'John' and Col2 = 1 and Col3 = date '2022-6-30'"),2),0)