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 D1n 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