Hi All,

I am looking to calculate the number of cells that contain "PASS" which is mixed amongst other cells. I can use COUNTIF, but can i apply this formulae to visable cells only?

I have added subtotal103, however i think this will only work if the other cells are blank.

Please help.

Thanks,

Adam