Hi,

I just noticed that you have two type combined into one total, to deal with
that try

=SUMPRODUCT(SUMIF($A$1:$A$10,{"C","D"},$B$1:$B$10) )

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"jimt" wrote in message
...
I would like to define a range to create a chart. The data spreadsheet is
divided into several sections of row with financial account groups
(similar
to departments). Each of the groups has a total line and a blank
separator
line between the groups. Each row has a "type" of account. So the data
sheet
look something like:

acct type amount
1 A 5.00
2 A 2.00
3 A 1.00
sub-total 8.00

4 B 1.00
5 B 2.00
sub-total 3.00

Group Tot 11.00

6. C 6.00
7. D 3.00
Group Tot 9.00

Grand total 20.00

Is there a way to define a non-contiguious range name or a pivot table
that
excludes the "totals" and blank rows so that the resulting chart displays
the
sum field for the different type?

Thanks
Jim T.