I am ranking answer for a form. and I came up with this formula

=ArrayFormula(QUERY({'LEADs oGV'!U:U,LEN('LEADs oGV'!U:U)},
 "select Col1, count(Col2) where Col2 > 0 group by Col1 order by count(Col2) desc limit 3",

The problem is that it does not count the number of blank answers in the given column! How can I do that without filling every single blank cell?

  • 1
    Can you share a sheet with us Brites and show us your expected outcome, so we can have a look? Jun 22, 2017 at 7:28
  • docs.google.com/spreadsheets/d/… Here it is! The tables in "Publico oGV", takes input from "LEADs oGV", which is exported from my company's software
    – Brites
    Jun 22, 2017 at 19:11

1 Answer 1


Maybe try:

=ArrayFormula(QUERY({'LEADs oGV'!U:U,LEN('LEADs oGV'!U:U)},
 "select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 4",0))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.