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!
[Solved] Text comprising number results from other cells
[Solved] Text comprising number results from other cells
Last edited by robleyd on Mon May 13, 2019 12:58 am, edited 2 times in total.
Reason: Add green tick
Reason: Add green tick
OpenOffice 4.x on various Windows platforms
Re: Text summary comprising number results from other cells
Code: Select all
="There are "&A10&" Canadians and "&A11&" Australians."
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Text summary comprising number results from other cells
See also CONCATENATE in the Help - F1
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: Text summary comprising number results from other cells
Thanks guys!
OpenOffice 4.x on various Windows platforms