Excel - sum a subtotal
Asked By RaulSous
22-Apr-08 11:36 PM
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?
Excel
(1)
SUMIF
(1)
Sousa
(1)
Raul
(1)
Cities
(1)
City
(1)
Fred Smith replied...
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.
Mark Ivey replied...
Check out the SUMIF formula...
Mark Ivey
RaulSous replied...
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 replied...
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.
Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002
32 bit DLL with 64 bit Excel 2010 Excel We have an app which creates large Excel workbooks. For example, one workbook has 1, 000 worksheets. In other cases there are fewer worksheets but the Excel file can be 80 MB or larger. Since this sometimes crashes Excel 2007 and 2003, I am considering using 64 bit Excel 2010. Would 64-bit Excel be more reliable with workbooks this size than 32-bit Excel? Is 32-bit Excel 2010 any more (or less) reliable with large workbooks than Excel
Pb de recalcul Excel Bonjour, J'ai un problème de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF cela soit automatique ? Merci d'avance à ceux qui se pencheront sur mon cas. Caroual Excel - French Discussions WorksheetFunction (1) AddIns (1) Worksheets (1) Excel 2007 (1) Macro (1) Proc (1) LEFT (1) VBA (1) Bonsoir Dans la doc sur 426a74cc@news.free.fr. . . Bonjour, J'ai un probl?me de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF e ou Bonjour, D??butons par une petite explication : Auparavant sous les versions ant??rieures ?? Excel 2007, si les 2 macros compl??mentaires ("utilitaire d'analyse" ou titre d'exemple directement est diff??rente, certains pourraient bien ??prouver des difficult??s. Tous (ou presque) savent qu'Excel sous les versions pr??c??dentes ?? Excel 2007, ne fait pas la traduction des fonctions d'une langue ?? l'autre lorsqu'elles
Excel and the Math Coprocessor for DLLs Excel I have a large Win32 DLL (10 MB) that is called from my user interface (written in C++) or from VBA in MS Excel. In my user interface, the DLL runs in its own space and calculates correctly. Under Excel VBA, my DLL is having problems with double precision accuracy. The following test passes in bottom CHPTST = (DIVTWO * bottom) - top In my user interface, the chptst result is zero. Under Excel VBA, the chptst result is 0.2851266E-09. I have tried resetting the math coprocessor _status87 (); if (old87Status ! = 0) new87result = _control87 (new87ControlWord, new87ControlMask); I have verified this behavior in both Excel 2003 and 2010. Does anyone have any ideas here ? Sincerely, Lynn McGuire Excel Discussions Windows XP (1) Visual Studio 2005 (1) Microsoft Excel (1) Visual Studio (1) Excel 2010 (1) Excel 2003 (1) Excel 2007 (1) Workbooks (1
Excel VBA recommendations Excel Hello I will be jumping into writing up some excel Marcos for some of our office bean counters. Any recommendations were to get or download create forms user input, move around within workbooks, sheets, etc. Any suggestions would be helpful Excel Programming Discussions Microsoft Excel (1) Front Page (1) Excel 2003 (1) Excel 2007 (1) Outlook (1) Charts (1) Excel (1) SUMPRODUCT (1) Did you try this site? http: / / visualbasic.about.com / library / courses / blecvba20404