SOLVED

Concatenate a count(range) with a string.

Copper Contributor

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?

2 Replies

@MonTor56 

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.

best response confirmed by MonTor56 (Copper Contributor)
Solution
That was the trick!
Thank you Hans! :)
1 best response

Accepted Solutions
best response confirmed by MonTor56 (Copper Contributor)
Solution
That was the trick!
Thank you Hans! :)

View solution in original post