Indirect(NamedRange) inside Sumproduct

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I'm trying to do this, but am having difficulty. Is it because my names
ranges are dynamic using Offset to define them? I'm guessing my only
alternative is to create a UDF.

Thanks,
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Sumproduct 6
Variable named range in worksheet function 6
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Drop Down with dynamic named range offsheet source list 14
INDIRECT Link of Variables for VLOOKUPs 6
Sumproduct Indirect Named Dynamic Range using Offset 6
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0

Back
Top