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