Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |