Table of Contents
Counting the number of filtered rows in Google Sheets can be done by following a few simple steps. First, select the range of cells that contain the data you want to filter. Then, click on the “Filter” icon in the toolbar or go to the “Data” menu and select “Create a filter.” This will add filter buttons to each column in your selected range. Next, click on the filter button for the column you want to count the filtered rows for and select the desired filter criteria. Finally, the number of filtered rows will be displayed in the bottom right corner of the screen. This method allows for an efficient and accurate way to count the number of filtered rows in Google Sheets.
Count Filtered Rows in Google Sheets (With Examples)
The easiest way to count the number of filtered rows in Google Sheets is to use the following syntax:
SUBTOTAL(102, A1:A10)
Note that the value 102 is a for taking the count of a filtered range of rows.
The following example shows how to use this function in practice.
Example: Count Filtered Rows in Google Sheets
Suppose we have the following spreadsheet that contains information about various basketball teams:
To add a filter to this data, we can highlight cells A1:B10, then click the Data tab, then click Create a filter:
We can then click the Filter icon at the top of the Points column and uncheck the box next to the first three values 84, 89, and 93:
Once we click OK, the data will be filtered to remove these values.
If we attempt to use the COUNT() function to count the number of filtered rows, the value will not be correct:
The number of filtered rows is 6, but the COUNT() function returns 7.
Instead, we need to use the SUBTOTAL() function:
We can manually verify this is correct by observing that there are 6 visible rows.
Additional Resources
Cite this article
stats writer (2024). How can I count the number of filtered rows in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-filtered-rows-in-google-sheets/
stats writer. "How can I count the number of filtered rows in Google Sheets?." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-filtered-rows-in-google-sheets/.
stats writer. "How can I count the number of filtered rows in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-filtered-rows-in-google-sheets/.
stats writer (2024) 'How can I count the number of filtered rows in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-filtered-rows-in-google-sheets/.
[1] stats writer, "How can I count the number of filtered rows in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I count the number of filtered rows in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.