ShoaibAli
Banned - Rules violations
- Joined
- Jan 15, 2020
- Messages
- 121
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
=COUNTA(IFERROR(QUERY(IMPORTRANGE($V$5,"QC sheet!A793:K850"), "Select Col5 where Col2 contains '"&E$3&"' and Col4 contains '"&$D5&"'",0)))
Above formula is working fine but when adding dates to count data date wise then it goes wrong.
Applying below formula but faild please help
=COUNTA(IFERROR(QUERY(IMPORTRANGE($V$5,"QC sheet!A793:K850"), "Select Col5 where Col2 contains '"&E$3&"' and Col4 contains '"&$D5&"' and date "&TEXT(Summary!$T$2,"'YYYY-MM-DD'")&" <= Col8 and date "&TEXT(Summary!$U$2,"'YYYY-MM-DD'")&" >= Col8 and Col1 is not null ",0)))
Above formula is working fine but when adding dates to count data date wise then it goes wrong.
Applying below formula but faild please help
=COUNTA(IFERROR(QUERY(IMPORTRANGE($V$5,"QC sheet!A793:K850"), "Select Col5 where Col2 contains '"&E$3&"' and Col4 contains '"&$D5&"' and date "&TEXT(Summary!$T$2,"'YYYY-MM-DD'")&" <= Col8 and date "&TEXT(Summary!$U$2,"'YYYY-MM-DD'")&" >= Col8 and Col1 is not null ",0)))
