ExcelBanter - 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