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