Here we will try to add the matrix (4X4 order)
1. Create a matrix as below (only accecories barcket, can be ignored)
![matrix addition](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK3FezPWJ70SwI96FbyoMQr5eoGEJHb0cF_J6z74Io7kdKyHlesCllGoXpKaFfsYS4YImxdm1nAzO1XAOWk0nB0G_rVrQC7F2qWPjhYY4AT0AaSz9iVq5DX4_DJzKr7rGyukupofM6k2nn/s400/jumlah+matrix+01b.jpg)
2. Block range to put the sum (adjusted the same order of a matrix that will add )
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxecZhlIRGW-anQOXe0yl62dfX_zNOQoiWywQzkZ2KdEIOi9raxGWGE-YwHMN-LrcgByh2XBvxxYc4SIxeB8Z1C7r4fPUDN0vfFU0I3zSXWOlXs1hKixzk2rZW2HYp0-quTl2qjizIUmKy/s400/jumlah+matrix+02b.jpg)
3. Type the formula:
= A4: C7-E4: G7
![matrix](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhztJ70cznhdGiWzC-XE3u-6U88vMa0Qy9svbLrROmNTmgLLqLrSTZeFypHPsbkN1IF39Ieo5Uk5NRxaYg2N5ZRZUckDhm5uo_PMmDB_uNI57dgH3_F7w_UlCc5E6ZYFLxctp6XsfZOLbs8/s400/jumlah+matrix+04b.jpg)
Perform array by pressing the key combination Ctrl + Shift + Enter
4. The result will look like the image below
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLV0DpSpBIyYhuMO3f3Ow9GGVszUVw5SSsBIeeBwEOXKdm_XO2XuvIIHo16eKoAPvLn8xw3ZuEsOo-2wqPkKXJ4TYPhamPYiQ46l_3vohlcPzFIzecGIXs7nBNZ8SQnEDALgthTynMJ4gl/s400/jumlah+matrix+05b.jpg)
No comments:
Post a Comment