Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect(NamedRange) inside Sumproduct
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect(NamedRange) inside Sumproduct
Is it because my names ranges are dynamic
using Offset to define them? Yes -- Biff Microsoft Excel MVP "Barb Reinhardt" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect inside a vlookup | Excel Worksheet Functions | |||
sumproduct with indirect | Excel Worksheet Functions | |||
How to Add NamedRange Controls to Worksheets? | Excel Worksheet Functions | |||
SUMPRODUCT & INDIRECT? | Excel Worksheet Functions | |||
Wildcard character inside sumproduct | Excel Worksheet Functions |