countif in a subtotal function

[rexmann]

Hi All

I am using the Subtotal function, is it possible to use the subtotal
function but to perform a countIF or equally any other alternative?

I am filtering and need the countIF and can't find a work around

Any help greatly appreciated

Kind regards

Rexmann

 

[Bob Phillips]

Here is an example

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C1,ROW($C$2:$C$20)-ROW($C$1),,1)),--($C$2:$C$20="Assigned"))