How to use a array as the input for a normal formula

R

Robin Lu

For example,
~ A B
1 a= 3
2 b= 4
3 a*b= 12

in cell B3, the formula is "=C2*C3",

Also in area A1~E2, we have two group of number
~ C D E F G
1 3 6 9 12 15
2 2 4 6 8 10
3 -

How to caculate C1 ? C2 and put the result into C3? Here ? means the
rule depend on the formula on cell B3.

Is it possible works only in excel sheet? Or can I call the formula
from external database? Appreciate any help or tips!
 
Top