You'll find a solution to a similar problem here.

http://www.excelforum.com/excel-2007...rcentages.html