Here is an example

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

--
__________________________________
HTH

Bob

"rexmann" wrote in message
...
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