Yes it will work

s = "Sumproduct(--(myrng=A1),--(myrng1=B1),--(myrng2=C1),myrng3)"

res = Evaluate(s)

would work with defined names myrng, myrng1, myrng2, myrng3

--
Regards,
Tom Ogilvy


"Wiley" wrote in message
...


I posted somehting like this last week, but the asnwe Irecieved was to use
SUMPRODUCT. Firs I am filtering the record set to match a date range.
THen
on that subset, I must use any of 3 to 10 different criteria in 2 columns
to
determine if a record is counted. So if a record matches one of the
values
in COlE and one of the picked vale in COl I, then it gets counted. I need
to
do this in VBA. Iif I use the EVALUATE, I can use the formula in code.
However, it will not work with name ranges (at least for me). Does anyone
know if you can use a named vairable range in SUMPODUCT instead of literal
cell references. This needs to be a repeatable process on data that will
get
refereshed and willnot have the same number of rows. I am not real
stroing
in VBA.

Thanks