| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating subtotals
(I'm using Excel 2007)
My spreadsheet has 500,000 rows. It has column labels: key amt1 amt2 amt3 amt4 amt5 At each change in "key", I need the sums of "amt1", "amt2", "amt3", "amt4" "amt5". When I use the Subtotal command in the Outline group on the Data tab, it takes more than 10 HOURS to calculate the subtotals and grand totals. Is there a faster way to compute the subtotals and grand totals? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating subtotals for sequential blank cells in 1 column | Excel Worksheet Functions | |||
| Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
| Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
| Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
Linear Mode
