Number of rows after filter on excel
Solved
ambrinette
-
ambrinette3 Posted messages 1 Status Member -
ambrinette3 Posted messages 1 Status Member -
Hello,
I have an Excel table with a filter on column B "Test passed=1"
I need to count, in column C, the number of candidates who scored an average of 8, 9, or 10. The problem is that when I apply a filter and use "COUNTIF()", the function counts everything, including the cells that are hidden by the filter, while I only need the filtered data. I tried the SUBTOTAL formula as seen on the forum, but it doesn't work (or I don't know how to use it). Thank you in advance for your response.
I have an Excel table with a filter on column B "Test passed=1"
I need to count, in column C, the number of candidates who scored an average of 8, 9, or 10. The problem is that when I apply a filter and use "COUNTIF()", the function counts everything, including the cells that are hidden by the filter, while I only need the filtered data. I tried the SUBTOTAL formula as seen on the forum, but it doesn't work (or I don't know how to use it). Thank you in advance for your response.