Basically, I have a spreadsheet that a variety of countif and countifs functions that I am using to analyze data with. I need these to count only visible cells after I apply the auto filter. Please see below:
=COUNTIFS(K2:K500, "Y", F2:F500, "Y")
This is the example I need to sove for and the rest of the functions have different cell range references but if I can get a solution on these two, I will be able to trnslate them to the rest f the worksheet. This is what I have tried:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(F2,ROW(F2:F500)-ROW(F2),0)),(F2:F500="Y")+0)
This will work when I am only counting the "Y" in column F. I obviously want it to count the "Y" when it appears in columns K and F on visible cells only. Your assistance is greatly appreciated.
Bookmarks