I had such a great experience with the help I received the other day on a similiar issue I am hoping someone will be able to help me out on this one again. I have attached my file as an example which is significantly scaled down from its original. What I need is different weights for each of my 3 criterias. These weights will be used later to determine various tracking sales. The weight need to be based on each lines Renewal WP (column S). I need a formula to calculate the following:

1-Column V: That lines Renewal WP/ Sum of the Renewal WP for that rows given Profit Center & Month & LOB
2-Column Y: That lines Renewal WP/ Sum of the Renewal WP for that rows given Profit Center & Month & LOB & UW
3-Column AB: That lines Renewal WP/ Sum of the Renewal WP for that rows given Profit Center & Month & LOB & BD

I have tried various combinations but this is getting a little over my head.
Any help would be greatly appreciated. If I have failed to explain this correctly or if there are questions, please just let me know. Thank you.Test Master List 3 for web.xlsx