sum a subtotal

[Raul Sousa]

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?

 

[Mark Ivey]

Check out the SUMIF formula...

Mark Ivey

 

[Fred Smith]

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]

I have Country in columns A and city in column B.
I have it sorted by country then by city.
My problem is that I need a sum by city then by country.
I can only do a subtotal. either by country OR by city. I need the subtotal
by country AND by city.

 

[Fred Smith]

In your first post, you said that both city and country were in column A.
That was the source of the confusion.

To do the subtotal, I'm assuming you are using the Data>Subtotal command. If
so, do it in two steps. First, subtotal by country. Then subtotal by city,
but uncheck the Replace current subtotals box. That will leave your country
subtotals in place, and add city subtotals.

Regards,
Fred.