View Single Post
Old 11-23-2016, 06:11 PM   #23
Fuzz
Franchise Player
 
Fuzz's Avatar
 
Join Date: Mar 2015
Exp:
Default

I'm not sure you can do it all in one cell, as you need to sum a new column first.
So make H=B5*G5 and fill down

Then new column I

I=H5/SUM(H$5:H$10)*D$2

If you have more rows, just change the H$10 in this formula to whatever the last row is.
Fuzz is online now   Reply With Quote
The Following 2 Users Say Thank You to Fuzz For This Useful Post: