Can anybody help me to find total of all the horizontal elements in each row of an array in a single cell without VBA code..
Values shown in the following table are basically the elements of an array derived from other excel formulas.
Purpose is to find the row number at which sum of horizontal elements is greater than a certain value.
Values shown in the following table are basically the elements of an array derived from other excel formulas.
Purpose is to find the row number at which sum of horizontal elements is greater than a certain value.
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | 0 | 0 | 0 | ={0;1;2;5;3;9;6;4;5;24} | |||
| 2 | 0 | 0 | 1 | ||||
| 3 | 1 | 1 | 0 | ||||
| 4 | 0 | 0 | 0 | 5 | |||
| 5 | 1 | 1 | 1 | 0 | |||
| 6 | 3 | 3 | 3 | ||||
| 7 | 2 | 2 | 2 | ||||
| 8 | 0 | 0 | 0 | 4 | |||
| 9 | 1 | 1 | 1 | 2 | |||
| 10 | 8 | 8 | 8 | ||||
Sheet1 | |||||||
) that MMULT is Excel 2013 and above formula.. funny... thank you very much for opening my eyes...
