I am having trouble with embedding INDIRECT inside SUMPRODUCT, too. Consider this formula:
=SUMPRODUCT(INDIRECT(D23),INDIRECT(E23))/SUM(INDIRECT(E23))
Cells D23 & E23 contain text functions that result in ranges A15:A23 & B15:B23.
The SUMPRODUCT/SUM statement works just fine. However, when I replace the (D23) & (E23) references with the text functions that produce the ranges I get the #VALUE error. What's strange is that the denominator works; the error is in the SUMPRODUCT. Does anyone know why? Must I keep the text functions separate from SUMPRODUCT?
Thank you!
Bookmarks