How does Excel know the difference between a country and a city?

Either put the cities and countries in different columns, or create a helper
column which identifies whether you have a city or country. Sort by country,
and then subtotal.

Regards,
Fred.

"Raul Sousa" wrote in message
...
I have on column A country and on column A City.
I want to have two subtotals.
I want to sum by city and then by country.

Is this possible?