array formula q
 

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?

array formula q
 

Try this:

=SUMPRODUCT(A1:A10,B1:B10,1-C1:C10)

Biff

"nickname" wrote in message
oups.com...
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?