Range of values

[willemeulen]

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.

 

[Jarek Kujawa]

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

 

[willemeulen]

Understand what youre saying but this will be manual, my goal is to automate
it so the sheet automatically gives the user a summary of the sheet. Like the
example; unique brands and amounts sold. The original column must remain.

 

[Eduardo]

Hi,
Create a summary sheet, Let's assume your information is in sheet1, create
another tab called Summary, and in column A enter the brands starting in row
1. I suppose that in Sheet 1 the brands are in column A and the total sold is
in Column B, so in column B from the summary sheet enter the formula as follow

=sumproduct(--(a1=sheet1!a:a),sheet1!b:b)

If you are not using excel 2007 enter the formula as follow

=sumproduct(--(a1=sheet1!$a$1:$a$1000),sheet1!$b$1:$b$1000)

Hope this help