Prorate amount

[gcotterl]

How can I prorate 2727.29 based on these original amounts?

A B C D
E Totals
1 1531.19 153.11 20.00 298.58 15.00 2017.88
2 6.60 .66
1.29 8.55
3 20.00 2.00
3.90 25.90
4 2.77 .27 .
54 3.58
5 211.08 21.10
41.16 273.34
6 3.47 .34 .
68 4.49
7 13.00 1 .30
2.54 16.84
8 27.60 2.76
5.38 35.74
9 566.27 56.62
110.42 733.31
10 171.75 17.17 20.00 33.49
242.41
Totals 2553.73 255.33 40.00 497.98 15.00 3362.04