SUMPRODUCT

[properties]

Looking at a recent post refering to SUMPRODUCT, can the range be replaced
with a named range. I would like to use this function but I need my range to
be dynamic since I would be added rows daily. I know how to make named range
dynamic. Or is there another alternatice using the SUMPRODUCT?

Pedro


=SUMPRODUCT((A12:A29="GroupX")*(G12:G29="A"))

 

[Vasant Nanavati]

What happens when you try it?

 

[Dave Peterson]

If you're asking how to create a dynamic name:

http://www.contextures.com/xlNames01.html#Dynamic

 

[Bob Phillips]

As Vasant says, the first thing to do when you wonder if something will work
or not is to try it. You say you know how to create dynamic named ranges, so
try it, and then shout if it doesn't work.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)