Sum after sorting

  • Thread starter Thread starter Peter
  • Start date Start date
P

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
 
Not sure if I understand, but possibly you want something like

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

Jerry
 
Dear Jane,

The formula is just =B2+B3.

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

Thanks
 
Back
Top