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 citie...
- That was the trick!
Thank you Hans! 🙂
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! 🙂