Jul 31 2020 08:15 AM
I tried =COUNT(a20:a30)&" of cities"and got "0 of cities".
I tried =concatenate(count(a20:a30)&" of cities") and got "0 of cities".
I tried =CONCATENATE(COUNT(A20:A30);" of cities") got "0 of cities".
All I wanted was "11 of cities".
What is wrong?
Jul 31 2020 08:19 AM
If you want to count the number of non-blank cells, use COUNTA instead of COUNT:
=COUNTA(a20:a30)&" of cities"
COUNT only counts numeric values, not text values.
Jul 31 2020 08:23 AM
SolutionJul 31 2020 08:23 AM
Solution