G

#### gary

My spreadsheet has column labels: key amt1 amt2 amt3

amt4 amt5

At each change in "key", I need the sums of "amt1", "amt2", "amt3",

"amt4" "amt5".

My speadsheet contains 232846 rows with amounts.

Between each "key", there's an empty row (i.e., 262062 empty rows)

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?