Hi all,
How can I get the result of this multi cell array formula in a single cell?
That formula gives different results when used as either single cell or multi cell. To discuss the formula I abbreviate it like this:Please Login or Register to view this content.
The result of a single cell is that the first value returned by the VLOOKUP (V) is multiplied with the sum or the ARRAY (A). The result I want is what you get when you run the formula in multiple cells: it multiplies the first value returned by V with the first value of A, the second with the second, and so forth. In short:Please Login or Register to view this content.
Single cell result: V1 * SUM(A)
multi cell result: V1*A1 + V2*A2 + V3*A3
Example:
data (A2:B5)
atom mass hydrogen 1 carbon 12 oxygen 16 chlorine 35
molecule (A8:B10)
atom amount carbon 2 hydrogen 6 oxygen 1
Use the given formula in any single cell and it will display 108 (9 x 12). Select two or more cells before entering this formula with [ctrl + shift + enter] and it gives 46. That is what I want.
Cor
Bookmarks