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