QUERY questions

[Jewells0905]

Hello,

I am trying to write a function to display country names for countries in Asia and the total number of people who can read for each of those countries, not including any country that has an empty cell in column F. Order the results by number of readers from high to low, and label the column with the number of readers "# of Readers" and ensure that the value is displayed as a whole number. I tried using this formula but it is only producing the headers. =QUERY(countries, "SELECT A, C * F / 100 WHERE B contains 'Asia' AND F is not null ORDER BY C * F / 100 DESC LABEL C * F / 100 '# of Readers'", 1)

This is a named range countries. And this is being done in Google Sheets

Country	Region	Population	Area (sq. mi.)	GDP ($ per capita)	Literacy (%)
Afghanistan	ASIA (EX. NEAR EAST)	31056997	647500	700	36.00
Albania	EASTERN EUROPE	3581655	28748	4500	86.50
Algeria	NORTHERN AFRICA	32930091	2381740	6000	70.00
American Samoa	OCEANIA	57794	199	8000	97.00
Andorra	WESTERN EUROPE	71201	468	19000	100.00
Angola	SUB-SAHARAN AFRICA	12127071	1246700	1900	42.00
Anguilla	LATIN AMER. & CARIB	13477	102	8600	95.00
Antigua & Barbuda	LATIN AMER. & CARIB	69108	443	11000	89.00
Argentina	LATIN AMER. & CARIB	39921833	2766890	11200	97.10

 

[Jewells0905]

I have a formula that works, however, I am not able to get the numbers to round. The formula I am using is =QUERY(countries, "SELECT A, C * F / 100 WHERE B contains 'ASIA' AND F is not null ORDER BY C * F / 100 DESC LABEL C * F / 100 '# of Readers'", 1) however, I can not get the round to whole number to work. When I try this formula it gives an error =QUERY(countries, "SELECT A, ROUND(C * F / 100) WHERE B contains 'ASIA' AND F is not null ORDER BY C * F / 100 DESC LABEL ROUND(C * F / 100) '# of Readers'", 1)

 

[Jewells0905]

=QUERY(countries, "SELECT A, C * F / 100 WHERE B contains 'ASIA' AND F is not null ORDER BY C * F / 100 DESC LABEL C * F / 100 '# of Readers'FORMAT C*F/100 '#'", 1) - correct formula