Fid you array enter it? TRANSPOSE even inside SUMPRODUCT always need to be
array entered

--
Regards,

Peo Sjoblom


"Jerry W. Lewis" wrote in message
...
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