Excel Help (Need a combination of functions to do analysis)

[Jay_Atm]

Hi,
This is Jay and i need help in sorting this out. Here with i am providing layout for better understanding my problem

I have a table which contains 3 columns with multiple rows and each provider might be having different service codes and its prices .

[TABLE="class: grid, ******* 100"]
[TR]
[TD]Provider[/TD]
[TD]Service[/TD]
[TD]Price [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pkey[/TD]
[TD]C[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LIOH[/TD]
[TD]NC[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bkey[/TD]
[TD]SR[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]

Requirement : In another table i have say 2 rows and 2 columns, in columns 1, row 1 you can see provider and column1, row 2 should have all the service codes frm the above table. In columns 2, row1 i should have an option for scroll down for Providers (LIOH or BKEY or PKEy) and in Column2, row2 it should give the total sum of service codes which belong to the selected provider.

[TABLE="class: grid, ******* 100"]
[TR]
[TD]Provider[/TD]
[TD]LIOH[/TD]
[/TR]
[TR]
[TD]All Services related to LIOH [/TD]
[TD]Sum should populate here[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]

I hope i have made it clear and can any one help me on this plz

Jay