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.
Last edited by Kirk3737; 01-12-2019 at 09:27 PM.
yeah, it's possible. it's explained in the file of my link below*Tips & Tutorials I Compiled, sheet 10
something along:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(G6,ROW(G6:G500)-ROW(G6),))*(G6:G500="yes"))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Awesome! Works perfect. Thank you benishiryo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks