[Solved] Text comprising number results from other cells

Discuss the spreadsheet application

[Solved] Text comprising number results from other cells

Postby ZekeMan » Fri May 10, 2019 11:23 am

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!
Last edited by robleyd on Mon May 13, 2019 12:58 am, edited 2 times in total.
Reason: Add green tick
OpenOffice 4.x on various Windows platforms
ZekeMan
 
Posts: 2
Joined: Fri May 10, 2019 11:01 am

Re: Text summary comprising number results from other cells

Postby Zizi64 » Fri May 10, 2019 1:21 pm

Code: Select all   Expand viewCollapse view
="There are "&A10&" Canadians and "&A11&" Australians."
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8234
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Text summary comprising number results from other cells

Postby robleyd » Fri May 10, 2019 2:05 pm

See also CONCATENATE in the Help - F1
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2954
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Text summary comprising number results from other cells

Postby ZekeMan » Sun May 12, 2019 5:00 pm

Thanks guys!
OpenOffice 4.x on various Windows platforms
ZekeMan
 
Posts: 2
Joined: Fri May 10, 2019 11:01 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 33 guests