one way would be to select a column with the brands
then (Excel 2003) Data-Filter-Advanced Filter-Copy to other
location (define yr criteria range)-Select Unique records only

HIH

On 7 Maj, 10:52, willemeulen
wrote:
It there any way I can summarize the range of values from a column. The
column contains manny repeats of values, let say car brand etc I want to
summarize the totals per brand at the bottom. I am using the sumif functions
to get the total numbers but how can I automatically show all the brands of
the sheet.