H
Hall
Suppose cells A1:A4 have values 1,2,3,4
If a cell has {=SUMPRODUCT(A1:A4)}, it gets the value 10.
If a cell has {=SUM(indirect(concatenate("a",row(A1),":a4")))}, it gets the
value 10.
But if a cell has {=SUMPRODUCT(indirect(concatenate("a",row(A1),":a4")))},
it gets the value 0.
Shouldn't that last case also have 10?
I've greatly simplified the examples for this question. I do have a purpose
for this formulation. But I seem to be unclear about this apparent
inconsistency.
Any help would be appreciated.
If a cell has {=SUMPRODUCT(A1:A4)}, it gets the value 10.
If a cell has {=SUM(indirect(concatenate("a",row(A1),":a4")))}, it gets the
value 10.
But if a cell has {=SUMPRODUCT(indirect(concatenate("a",row(A1),":a4")))},
it gets the value 0.
Shouldn't that last case also have 10?
I've greatly simplified the examples for this question. I do have a purpose
for this formulation. But I seem to be unclear about this apparent
inconsistency.
Any help would be appreciated.