sum a subtotal
 

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?

sum a subtotal
 

Check out the SUMIF formula...

Mark Ivey

"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?

sum a subtotal
 

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?

sum a subtotal
 

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" wrote:

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?

sum a subtotal
 

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 DataSubtotal 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.

"Raul Sousa" wrote in message
...
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" wrote:

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?