I was think also that you could make this more intuitive as well as
more efficient by locally defining a named formula that you could use
in any column, based on group names being listed in colA.

1. Select a cell in ColB.

2. In the name box:
'SheetName'!GroupTotal

3. In the RefersTo box:
=SUMIF($A:$A,TaskName,B:B)

...where the formula will automatically adjust to collect amounts in
whatever column you want group totals for. Note that this formula uses
the defined name I posted yesterday.

Simply enter into cells where you want totals:
=GroupTotal

Note that this formula doesn't require grouping and so task names can
be in any order.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc