Group Cells and Rank based on values

I have a worksheet with 2 rows of data. The first row contains heading information and the second row contains values. I need to rank the values and their sums while keeping the heading information attached.

Attached is an example worksheet.

Thanks for your help!