Page 1 of 1

[Solved] Text comprising number results from other cells

PostPosted: Fri May 10, 2019 11:23 am
by ZekeMan
Hi there!

Any idea how I can mix formula results (numbers) with text?
I'm using the CountIf() function to count the number of occurrences of two-letter country codes within a column. For example:
In cell A10: =COUNTIF($V$4:$V$1500;"=ca")
In cell A11: =COUNTIF($V$4:$V$1500;"=au")
...and so forth.

This is working fine, but what I'd like to do next is summarize everything, as in "There are ___ Canadians and ___ Australians."
To do that I'd have to reference the results of cell A10 and A11.

I've tried experimenting with the Text() function to no avail. Perhaps I've got the wrong syntax. Can anyone help with a formula for the above?

Thanks in advance!

Re: Text summary comprising number results from other cells

PostPosted: Fri May 10, 2019 1:21 pm
by Zizi64
Code: Select all   Expand viewCollapse view
="There are "&A10&" Canadians and "&A11&" Australians."

Re: Text summary comprising number results from other cells

PostPosted: Fri May 10, 2019 2:05 pm
by robleyd
See also CONCATENATE in the Help - F1

Re: Text summary comprising number results from other cells

PostPosted: Sun May 12, 2019 5:00 pm
by ZekeMan
Thanks guys!