Monday, October 10, 2011

How to count filtered data in Excel 2007

Let's say you have filtered some rows of an excel sheet by a certain value etc. These rows will not be in proper numbering since some rows will be filtered away and the filtered rows will be numbered like, 1 ,4 7, 8 and so on, for an example. So the function COUNT will not be useful here.
The solution for this is:


Here the parameter 3 is the number of a function and it is the function COUNTA and the A2:A15 is the filtered range.

In this way you can get the count of the filtered rows of data!