Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |