Applying a countif formula only to visible cells in a filtered list in Excel
The title pretty much sums the query up. I have a table of data with formulas (eg COUNTIF ) applied to each column.
When I filter the column, by date range or region, say, I would like the formula to return the result just for the visible (filtered) entries.
This is the same concept as the SUBTOTAL formula, which provides this
functionality but only on a limited number of functions (SUM, AVG,MAX etc).
Any help solving this would be much appreciated.
This is a well know formula on the various forums. To count the "B"s in the
range A2 to A100.