Function Help
Thanks alot, all great suggestions.
"el_horse" wrote:
Wahine wrote:
Hi there, I have 9 coloumns in a simple spreadsheet that looks like this:
if you chabge "x" to 1 (ctrl+h to change cells within a selection) you
can use a simple formula (a1:g1) is the percentages and h2 is the
amount
i2=h2*sumproduct($a1:$g1,a2:g2)
and then copy down the formula to h3,h4,...
to copy down you can select the h2:hX (where X is the last row you want
the formula copied) and press ctrl+d
regs
el horse
|