My formula =COUNTIF(G6:G500,"*Yes*")
Can someone help me find a formula that would count only the visible filtered cell? When filtered, I just want it to count the visible cells with text "Yes" . It would be great if SUBTOTAL formula could be combined, but I don't think that's possible.
Bookmarks