Forum Discussion
Solved
Concatenate a count(range) with a string.
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?
- That was the trick!
Thank you Hans! 🙂
2 Replies
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.
- That was the trick!
Thank you Hans! 🙂
