Hello,

I am having trouble figuring out how to count the values in a column that are less than 100 after it has been autofiltered. The column (column E) contains only numbers, and is filtered down based on autofilters applied to columns A, B, C, and D. What I want to know is the number of values in column E that are less than 100. Normally (with no filters), I would just do =COUNTIF(E:E, "<100") and get my result, however this obviously doesn't work after autofiltering. I was hoping to use the subtotal function, but there isn't a countif option, I'm not sure how to approach this problem. Any help would be appreciated.

Thank you.

(using Excel 2010)