searching for values and summing the corresponding values

[Simon]

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.

[Biff]

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 Data>Filter>Advanced 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.
>
>.
>