Skip to main content

Vector Dot-Product in Microsoft Excel

user warning: Got error 28 from storage engine query: SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 252 ORDER BY v.weight, t.weight, in /home1/seonetas/public_html/neohide/modules/taxonomy/taxonomy.module on line 640.

Dot-product, or rather vector dot-product, does not have a familiar phrase to use in Microsoft Excel. For instance, if you want to perform the following operation,


which exactly resembles that of a vector dot-product; that is, A*B where A = [A1 A2 ... AK] and B = [B1 B2 ... AK]T.

(Quick way to obtain the dot-product in Excel...)

Here is the quick way to do that in Microsoft Excel.

For the similar expression above, simply use the built-in function, SUMPRODUCT(). For example,


And the resulting vector dot-product is easily calculated with Microsoft Excel.

Why can't they put this in the help file?

Why, oh why, can't Microsoft include something in the Help file that would let me find this? A cross reference to dot-product, or vector, or array? Arrgh!