Internally assigned List or Tablename of Auto-Filter?

  • Thread starter Thread starter JMay
  • Start date Start date
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,
 
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))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula referencing a column -> autofilling in a row ??? 2
Auto filter for multiple columns 2
Filter Per Relative Criteria 2
SUBTOTAL not refreshing when using advanced filter 2
VBA Calculation on "only" Filtered Visible Cells 0
Counting number of days excluding certain values 3
Help with script: STARTING A NEW SUB.. (within sub?) 11
maybe by sumproduct or some other way with text. 4

Back
Top