Hi ldehn
See the formula below, is this something that you could work with! You can replace the double quotes with whatever you require if the logical part is false, at the moment if it is false, it will display a empty cell.
=IF(AND(C20,C30,C40,C50,C60),SUMPRODUCT(C2:C6 ,E2:E6),"")
Kevin
Quote:
Originally Posted by ldehn
I want to write an equation that says if E20, E30, E40, E50, and E60 then I would take C2*E2, plus C3*E3, plus C4*E4, plus C5*E5, plus C6*E6. So for example C2=400, C3=400, C4=450, C5=500, C6=550, E2=200, E3=0, E4=100, E5=0, and E6=150. What I want to get for a total is 207,500. Taking C2*E2+C4*E4+C6*E6. Can anyone help me?
|