Remove unwanted rows from Query response-CodePudding

I have this query where I pull data from another sheet.

=QUERY(Dump!A:F, "SELECT A,F, COUNT(C) GROUP BY A,F label count(C) ''")

The response I get is this one:

I´d like to NOT have the 0 row and the headers row. How can I do this?

CodePudding user response：

As provided by @MattKing, you can use this formula to remove the 0 row

=QUERY(Dump!A2:F,"SELECT A,F, COUNT(C) where A<>'' GROUP BY A,F label count(C) ''")

Or you can exclude the header using 0 value as stated by @doubleunary

=query(Dump!A1:F, "select A, F, count(C) group by A, F label count(C) '' ", 0)