Trying report data with multiple values linked to a cell with the same value.

[hammerhead13]

Basically I am trying to figure out how to take a Cell "transaction #", find the most expensive item and then count all the items that are remaining from the transaction.

Example of Raw Data
Transaction # Item Price
100101 Item 1 199.99
100101 Item 2 4.99
100101 Item 3 20.99
100102 Item 1 300.99
100102 Item 2 45.99
100102 Item 3 42.99
100102 Item 4 35.99


Report Information Needed
Transaction Primary Item Price (Highest) Attached Item Total (everything else)
100101 199.99 25.98
100102 300.99 124.97

[NBVC]

In B14:

=MAX(IF($A$3:$A$9=A14,$C$3:$C$9))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down.

in C14:

=SUMIF($A$3:$A$9,A14,$C$3:$C$9)-B14

confirmed with just ENTER and copied down.