If you are going to use a filter then you don't need a formula like this,
filter on blanks in M and P in C then just count the visible cells in A

=SUBTOTAL(2,A4:A96)

If you still want a formula and all your data starts in row 4 with headers
in 3 you can use

=SUMPRODUCT(--(ISBLANK($M$4:$M$96)),--(TRIM($C$4:$C$96)="P"),--(ISNUMBER($A$4:$A$96)),SUBTOTAL(3,OFFSET($A$4,ROW( $A$4:$A$96)-MIN(ROW($A$4:$A$96)),,)))


although I would probably change remove isblank and use range=""


=SUMPRODUCT(--($M$4:$M$96=""),--(TRIM($C$4:$C$96)="P"),--(ISNUMBER($A$4:$A$96)),SUBTOTAL(3,OFFSET($A$4,ROW( $A$4:$A$96)-MIN(ROW($A$4:$A$96)),,)))

This formula can be entered normally as opposed to your COUNT formula


--


Regards,


Peo Sjoblom


"ub" wrote in message
...
Hi
I have the following formula in one of the cell
=COUNT(IF((TRIM($C$4:$C$96)="P")*ISBLANK($M$4:$M$9 6),$A$4:$A$96))

But I have autofilter command and I want the rows to be counted based on
the
output of the filter results. But this formula always gives the output os
the
rows.

Please help