software

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?Goto the Data menu and select Subtotals

Biff

quot;Kyliequot; gt; wrote in message
...
gt; In the old days I remember a sub total and grand total formula in Lotus.
gt; How
gt; can I achieve the same results in Excel?
gt;
gt; Column A
gt; 2
gt; 2
gt; sub total formula = 4
gt;
gt; 3
gt; 3
gt; sub total formula = 6
gt;
gt; grand total formula = 10
gt;
gt; The grand total formula would only add up all the cells in the column and
gt; exclude the sub total formulas.
gt;
gt; Or am I dreaming?
gt;
the formula you require is: quot;subtotal(9;range)quot;. the first parameter is 9 if
you require subtotals being made in combination with the autofiltersystem.
below you find an examle.
clientnamejanfebmartotal
ABC Wireless 50030050850
Top Wireless 40025050700
ABC Wireless 25025050550

totals265015503004500Selection in % of grand total
subtotals1150800150210046,67%If A1:A6 ABC Wireless is found than add the B,C,D columns that's in same row

and sum it in E row
column headings can contain month info or product info; time related info
can be added in each record(row) if so required.

1Understand you have a database which should give info at regular intervals
or at any time you like.
2Totalising more than one record(row) in column E cells would create
interpretation risks.
3Suggest you use the quot;autofilterquot; in combination with the quot;subtotalquot;
formula.
4You should avoid the risk of typing differences in the name of
clients.(especially if yr database is fed by various people)

autofilter:Select yr databank;in menu DATA select FILTER and
AUTOFILTER.
SUBTOTAL is a formula with a most interesting first parameter. In this case
use 9. formula reads as follows:=SUBTOTAAL(9;B4:B9)
FYG test also other first parameters than 9.If yet unknown it will upgrade
yr knowledge of excell.

quot;Kyliequot; wrote:

gt; In the old days I remember a sub total and grand total formula in Lotus. How
gt; can I achieve the same results in Excel?
gt;
gt; Column A
gt; 2
gt; 2
gt; sub total formula = 4
gt;
gt; 3
gt; 3
gt; sub total formula = 6
gt;
gt; grand total formula = 10
gt;
gt; The grand total formula would only add up all the cells in the column and
gt; exclude the sub total formulas.
gt;
gt; Or am I dreaming?
gt;