Hello,
How i can use COUNTIFS with some columns in different spreadsheets

Instead A column in the same spreadsheet i want to choose column in another spreadsheet

=COUNTIFS(A:A, ">="&K3, A:A, "<="&L3, I:I, K7)

I tried this formula =COUNTIFS("https://docs.google.com/spreadsheets/d/1_0a_Y679oQeGUvvr5HP2dyk9fwCF3LhWyEurc0cNGlA/edit?usp=sharing","Leads!A:A", ">="&K3("https://docs.google.com/spreadsheets/d/1_0a_Y679oQeGUvvr5HP2dyk9fwCF3LhWyEurc0cNGlA/edit?usp=sharing","Leads!A:A"), "<=
"&L3, I:I, K6)

and I tried this formula with Importrange, But it didn't work

Does anyone have a solution?
Thanks in advance

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)