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