searching for values and summing the corresponding values
 

Hi i have a table with a list of companies, which in some cases are
duplicated, and next to each company is a corresponding value. I want to be
able to return another table which returns the corresponding value for a
company, but if a company is duplicated then that company should only appear
in the returned table once but the value beside should be the sum of its
values. For instance i have

(First Table)
Company Amount
RBC 500
Suncorp 400
RBC 200

(2nd Table - What i would like returned)
Company Amount
RBC 700
Suncorp 400

Thanks
Simon.

Hi!

Extract a list of the unique company names to another
location then use a SUMIF formula.

Assume your table is in the range A1:B4 with A1 and B1
being headers.

Select A1:A4
Goto DataFilterAdvanced Filter
Select Copy to another location
Copy to - enter where you want the new list to appear
Select Unique records only
OK out

Assume the filtered list is in the rangge D1:Dn with D1
being the header. Enter the Amount header in E1.

In E2 enter this formula and copy down as needed:

=SUMIF(A$2:A$4,D2,B$2:B$4)

Biff

-----Original Message-----
Hi i have a table with a list of companies, which in some
cases are
duplicated, and next to each company is a corresponding
value. I want to be
able to return another table which returns the
corresponding value for a
company, but if a company is duplicated then that company
should only appear
in the returned table once but the value beside should be
the sum of its
values. For instance i have

(First Table)
Company Amount
RBC 500
Suncorp 400
RBC 200

(2nd Table - What i would like returned)
Company Amount
RBC 700
Suncorp 400

Thanks
Simon.

.