Hi Sajan

please allow me..

Hi Abhi..

For MMULT's detail explanation.. check here..

http://www.mathwarehouse.com/algebra/matrix/multiply-matrix.php
after reading above post..

So to multiply two Array, we have only one

**RULE**..

unlike SumProduct
* Number or COLUMN in 1st array, and number of ROW in 2nd array need to be same..

* and you cant multiply more than 2 array..

So we can create the 1st array's Number of Columns.. by any formula.. but to use MMULT, 2nd Array should have same number of Rows

Sajan mostly use TRANSPOSE to create next Array, with same number of Rows .. according to number of column in 1st array..

so to create an array {1,1,1,1,1} 5 item in a VERTICAL Array (

**;** Represent HORIZONTAL &

**,** represent VERTICAL Delimeter)

you can use Transpose(Row(A1:A5)) which is basically {1,2,3,4,5}

but you need all as 1.. like {1,1,1,1,1}

* Now another math..

**Anything** to the power 0 is 1, .. i.e

*99^0 = 1*
* In math's language.. {1,2,3,4,5}

**ToThePower** 0 is equivalent to {1,1,1,1,1}

and in Excel Language.. {1,2,3,4,5}

**^** 0

* Sajan mostly use

**=TRANSPOSE(ROW(A1:A5)^0)** to create the second array of MMULT..