Sum after sorting

[Peter]

There is an Excel Spreadsheet like the following

Project Value Sum
Power 120 354 (Power + Computer)
Computer 234
AV 123
Quest 200

There is a requirement that we have to sort Project in
ascending order but keep the sum unchanged (as follow)

Project Value Sum
AV 123 354
Computer 234
Power 120
Quest 200

I have tried a number of ways but still cannot get it
fixed. Is there any suggestion ?

Thanks

 

[Jerry W. Lewis]

Not sure if I understand, but possibly you want something like

=VLOOKUP("Computer",A1:B5,2,False)+VLOOKUP("Power",A1:B5,2,False)

Jerry

 

[Jane]

What is the formula that you have in there now?

 

[Peter]

Dear Jane,

The formula is just =B2+B3.

I have tried =B$2 + B$3 but still doesn't work.

Thanks