Hi,

I am wondering what my options are regarding sumproduct and array formulas.

i know i can use indirect in these formulas like:
=sumproduct(--(indirect(A2)<>1)*(indirect(b2)<>1))
where A2 might be a named range...

but am i able to capture more with an indirect?

What I would like to be able to is have an indirect reference a cell that has all of my parameters in it...

e.g., =sumproduct(indirect(G1))
where G1 = --(indirect(A2)<>1)*(indirect(b2)<>1)

The reason i want to do this is, because i want to be able to construct the parameters of an array or sumproduct without going into each formula to edit it.

Does this make sense?

Josh