Thread
:
Excel questions thread
View Single Post
11-23-2016, 06:11 PM
#
23
Fuzz
Franchise Player
Join Date: Mar 2015
Exp:
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.
The Following 2 Users Say Thank You to Fuzz For This Useful Post:
calumniate
,
RW99
Fuzz
View Public Profile
Send a private message to Fuzz
Find More Posts by Fuzz