Internally assigned List or Tablename of Auto-Filter?

J

JMay

My Cell B4 is returning my Current Auto-Filter Criteria;
In C4 I have:


=SUMPRODUCT(($B$12:$B$190=B$4)*(SUBTOTAL(9,OFFSET($A$12:$A$190,ROW($A$12:$A$
190)-MIN(ROW($A$12:$A$190)),,1))))

If I add a new record to say Row 191 the above **IS NOT** Picking up the
data
in my cell C4, obviously.
How can I make the above formula Dynamic (auto-expand to pick up all
additions)?

TIA,
 
F

Frank Kabel

Hi
easiest way: make the range large enough :)
=SUMPRODUCT(($B$12:$B$1900=B$4)*(SUBTOTAL(9,OFFSET($A$12:$A$1900,ROW($A
$12:$A$
1900)-MIN(ROW($A$12:$A$1900)),,1))))
 
Top