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)