Here is my formula:

=QUERY('2021 Report'!E3:E76;"SELECT E, COUNT(E) GROUP BY E ORDER BY COUNT(E) DESC LABEL (E) 'COUNTRY'";0)

Here is the results

It's returning the count as header. I want just the numbers. Is there any way to remove this count header?

CodePudding user response：

Try-

=QUERY('2021 Report'!E3:E76;"SELECT E, COUNT(E) GROUP BY E ORDER BY COUNT(E) DESC LABEL (E) 'COUNTRY', COUNT(E) ''";0)

CodePudding user response：

Try (no headers)

=QUERY('2021 Report'!E3:E76,"SELECT E, COUNT(E) GROUP BY E ORDER BY COUNT(E) DESC label COUNT(E) ''",0)