combine like items and sum

[chapm4]

Hi,
Sure this is simple for regular users (I'm just not).

I have two columns, first is road name and second is mileage. The roads are broken out from my GIS into segments. For instance Main St might have 6 segments because of crossroads.

I need to combine the like road names and sum the mileage so those six segments have one entry.

Please help.

[TMS]

Look at SUMIF

=IF(A:A, "Main St", B:B), for example

Regards

[chapm4]

Thanks for the answer on sumif. My problem then lies in the fact that I have approx 100 different road names and my understanding of sumif is I would enter each road name in the function. Don't think that would work.

Any more ideas?

[TMS]

Some. Post a sample workbook with some typical data for more specific advice.

Regards

[chapm4]

Here is a small sample of what I am talking about:

RD_NAME GRA_LEN_MI
AIRPORT RD 0.181180595
ALSOP LN 0.085506665
B RICE RD 0.555444203
B RICE RD 1.379248004
BAKER LN 0.949159738
BAKER LN 0.508002681
BAKER ST 0.059345549
BATES HOLW RD 0.547248937
BATES HOLW RD 0.011189400
BATES HOLW RD 1.545798445
BEAUCHAMP LN 1.344686710
BEAUCHAMP LN 0.541628428
BOLING LN 0.154529973
BOYD HARRIS RD 1.410542636
BROADWAY ST 0.197358336
BRUNER LN 0.123761306
BUCK POWERS RD 0.233638280
BUCK POWERS RD 0.582730235

[JBeaucaire]

Use the Advanced Filter on the column of street names to get a secondary list of UNIQUE values, perhaps in column G. Then put in a SUMIF() in column H as suggested already, then copy down.

In H2:
=SUMIF(A:A, A2, B:B)