How to sum the products of equations triggered by an if statement from another cell

[kgng100]

Hi

I am using Excel 2003 and I have two columns that I would like to work with. I would like to use the formula in a summary cell at the top,

=IF($O92=1, 0.5%*$E89, 0)

But I would like to run this on the whole column so that if O102 was = 1 then it would equate E99*0.5% likewise if O112 = 1 then it would equate E109*0.5% and then also sum all of these products into one cell.

Can this be done? I have tried all sorts but my excel knowledge is limited. Anyhelp would be appreciated.

Thanks

 

[barry houdini]

Try using SUMIF, something like

=SUMIF($O92:$O203,1,$E89:$E200)*0.5%