Try

=SUMPRODUCT(SUBTOTAL(3,OFFSET(V7:V197,ROW(V7:V197)-ROW(V7),0,1)),--(V7:V197="Closed"))

Mike

"Sjur" wrote:

I have å spreadsheet with the following count function:
=COUNTIF(V7:V197;"Closed")
=COUNTIF(V7:V196;"Open")
This gives me the sum of cells containing Open/Closed.

After applying a filter in B:7 I still get the same number of open/closed.
Is it possible to use countif, or similar, to count numers of open/closed
records in V:7-197 after filtering ?