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
Bookmarks