Goto the Data menu and select Subtotals

Biff

"Kylie" wrote in message
...
In the old days I remember a sub total and grand total formula in Lotus.
How
can I achieve the same results in Excel?

Column A
2
2
sub total formula = 4

3
3
sub total formula = 6

grand total formula = 10

The grand total formula would only add up all the cells in the column and
exclude the sub total formulas.

Or am I dreaming?