Matrix addition

 Microsoft excel provides a function to martix addition. Add process in accordance with the rules of the matrix, the matrix can be added if they have the same order.
Here we will try to add the matrix (4X4 order)

1. Create a matrix as below (only accecories barcket, can be ignored)





2. Block range to put the sum (adjusted the same order of a matrix that will add )



3. Type the formula:
= A4: C7-E4: G7



Perform array by pressing the key combination Ctrl + Shift + Enter

4. The result will look like the image below

Related Posts by Categories