1) mathematically can someone tell me whats going on or the steps taken when one range of cell is selected and multiplied by another range or cells?
thanks.
A | B | C | D | E | F | G | H | I | |
1 | |||||||||
2 | 1 | 2 | 5 | 6 | 5 | 12 | |||
3 | 3 | 4 | 7 | 8 | 21 | 32 | |||
4 |
Thanks. What is Excel saying? Why does it select the first cell in the matrix valued 5 when CSE is performed?