Fairly new to using Query functions. One thing I’m running into is that I’m trying to perform a COUNT on a range of cells. For some reason, the code below inserts the text “count” into the last column of my sheet and I don’t know how to avoid it.
=SORT(QUERY('Latest Submissions'!C:M,"SELECT C, count(F) where F is not null group by C",0),2,TRUE)
The query does what I need it to do, but the result is the following: