Depending on your data you could probably get a pivot table to work. Select
the data and choose

Data - Pivot Table & Pivot chart
When the wizard pops up just select finish (that will ususally work just fine)

Drag the Asset and Sector into the left column of the table and the price
into the center data section.
--
HTH...

Jim Thomlinson


"Amy" wrote:

I have the following set of data in a spreadsheet. I'm looking for a formula
that will sum the price of 2 carrier sectors.

For example, lines one and two are in sector X of Asset 860306, so I'd want
the formula to search and add the price column for those together. Likewise,
I'd want lines 3 and 4 to sum because they are the two carriers on sector Y
of asset 860306.

However, when you get to lines 7, 8 and 9, asset 860303 only has one carrier
on each sector so I would just want to capture the price of each individual
sector.

It's a long list. Any thoughts on how to do this programmatically?

Fullkey Sectkey Name Asset Number Sector Carrier Price
1005-X-1 1005-X BAX 860306 1005 X 1 2.41
1005-X-2 1005-X BAX 860306 1005 X 2 1.671
1005-Y-1 1005-Y BAX 860306 1005 Y 1 1.621
1005-Y-2 1005-Y BAX 860306 1005 Y 2 1.764
1005-Z-1 1005-Z BAX 860306 1005 Z 1 3.561
1005-Z-2 1005-Z BAX 860306 1005 Z 2 0.347
1002-X-1 1002-X BLKM 860303 1002 X 1 2.492
1002-Y-1 1002-Y BLKM 860303 1002 Y 1 3.036
1002-Z-1 1002-Z BLKM 860303 1002 Z 1 6.375
1068-X-1 1068-X BLO 860364 1068 X 1 2.758
1068-Y-1 1068-Y BLO 860364 1068 Y 1 2.577
1068-Z-1 1068-Z BLO 860364 1068 Z 1 3.249