Oct 7, 2019
Query giving erroneous "empty output" and Count(Query()) is summing not counting the results
On the sheet above, there are two highlighted cells in the D/F 9-23-19 tab. These are giving me issues. in the one, it is yielding "232" which is the sum of the results of a query, rather than the count of the results (should be 132; I know because when you run a regular query, it yields 132 rows). The highlighted cell in Column I should return a "1" because I added an entry to the "2019 RR Sign Ins" tab so that it would. Whatever is wrong with that formula is wrong with the whole column and several others. By the way, can I use an arrayformula there to simplify everything?
Thanks in advance!
Ben
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies
Oct 7, 2019
there does seem to be 232 records which include 09 in column D7:D - so query is correct in c2
regarding formula in i19 - this should be COUNTA - not COUNT - as we are counting text - not numbers