Count all except filtered data

  • Thread starter Thread starter andy62
  • Start date Start date
A

andy62

I have used versions of the basic formula below to count the records
remaining after application of the advanced filter:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A1,ROW($A$2:$A$19)-ROW($A$1),,1)),--($C$2:$C$19>20)),--($C$2:$C$19<=50))

Is there any way to change the OFFSET part to reference the opposite: all
rows HIDDEN after application of the advanced filter? I don't see this
question having been asked before, which is surprising.

TIA
 
Maybe just COUNTA the whole range you're interested in and then just subtract
your filtered result......


Vaya con Dios,
Chuck, CABGx3
 
I don't see this question having been asked before
which is surprising.

I've never seen it either!

The formula counts all visible rows that meet the condition. So, if you want
the "opposite", wouldn't it just be the total count of all rows minus the
result of your formula?
 
Back
Top