countif in a subtotal function

  • Thread starter Thread starter rexmann
  • Start date Start date
R

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
 
Here is an example

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