Since you know a PivotTable does what you want why not use one?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"christopher ward" wrote:

hi all and thanks if you respond

a quick question if you have a range full of values how do you create a
total function that breaks the amounts by a break point similar to the pivot
table function - for those who know Oracles OLAP DML or Express Server or
Personel Express my example is

limit product code to all
limit brand to all
report width 30 total(sales brand )

where product code has been related to brand

so can we force excel to do this easily


--
C Ward