I have a range A10:C10. For each row, I would like to multiply the
actual values in column A and B and (1-column C value) and then sum the
products of each row. For example, (A1*B1*(1-C1)
+A2*B2*(1-C2)+Ai*Bi*(1-Ci)). I believe I need to use an array formula,
but cannot seem to get it to work. Can anyone provide a solution or
source for me to do more investigation?