I have a "summary" worksheet which summarizes some of the key data found in other worksheets within the same workbook. The data in each of the detailed worksheets has the data filtered already. I know how to use the subtotal function to count the number of cells found in data filtered column, but I want to only count the cells in that filtered column that have a value over 30. BTW, changing the data filter is not an option for what I want to show. Attached is the spreadsheet so you can see exactly what I'm trying to accomplish.
Bookmarks