SUMPRODUCT
 

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"))

SUMPRODUCT
 

What happens when you try it? :)

--

Vasant

"properties" wrote in message
...
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"))

SUMPRODUCT
 

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

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



properties wrote:

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"))

--

Dave Peterson

SUMPRODUCT
 

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)

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What happens when you try it? :)

--

Vasant

"properties" wrote in message
...
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"))