| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Another SUMPRODUCT array anomaly
In an otherwise empty worksheet, enter 1 in G1 and I1 and a number (<0)
in I5. Now, in each of C1:C2 enter the formula =SUMPRODUCT((I1:DV1=1)*TRANSPOSE(G1:G118=G2),I5:DV 5) Why does the result of this formula depend upon the cell that it is entered in? How is the formula in C2 returning the value in I5 even though (I1:DV1=1)*TRANSPOSE(G1:G118=G2) should be an array of zeros? Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
| How can I use a cell reference in Sumproduct array formula? | Excel Discussion (Misc queries) | |||
| sumproduct help | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
