Query Fromula

[ShoaibAli]

Using below formula to get result but failed please help.



=COUNTA(IFERROR(QUERY(IMPORTRANGE("Sheet1","QC sheet!A792:B10000"), "Select Col2, Col4 where Col2 contains '"&B$1&"' and Col4 contains '"&C1&"' and date "&TEXT(G1,"'YYY-MM-DD'")&" <=Col1 and date "&TEXT(H1,"'YYY-MM-DD'")&" >=Col1" ,0)))

 

[MARK858]

I think that you would probably be better off posting this question on a Google sheets forum as with this being an Excel forum very few have many dealings with Google sheets (especially as you are using Query).