Table of Contents
To count the number of non-empty cells in a selected range in Google Sheets, utilize the COUNTA function. This function will return the total number of cells within the selected range that contain any type of data, including text, numbers, and formulas. Simply select the desired range, insert the COUNTA function, and specify the range as the function’s argument. This will provide an accurate count of all non-empty cells within the selected range.
COUNTA
Returns the number of values in a dataset.
Sample Usage
COUNTA(A2:A100,B2:B100,4,26)
COUNTA(1,2,3,4,5,C6:C20)
Syntax
COUNTA(value1, [value2, ...])
value1– The first value or range to consider when counting.value2, ...– [ OPTIONAL ] – Additional values or ranges to consider when counting.
Notes
Although
COUNTAis specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.COUNTAcounts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace). To count unique values, useCOUNTUNIQUE. To count only numeric values useCOUNT.
See Also
MODE: Returns the most commonly occurring value in a dataset.
DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.
DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.
COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.
COUNTIF: Returns a conditional count across a range.
COUNTBLANK: Returns the number of empty cells in a given range.
COUNT:
Returns the number of numeric values in a dataset.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdGpvSWFLVE0wMVpXR1kwVjM4ZUZmdVE&output=html” width=”500″]
Cite this article
stats writer (2024). How can I count the number of non-empty cells in a selected range in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-non-empty-cells-in-a-selected-range-in-google-sheets/
stats writer. "How can I count the number of non-empty cells in a selected range in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-non-empty-cells-in-a-selected-range-in-google-sheets/.
stats writer. "How can I count the number of non-empty cells in a selected range in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-non-empty-cells-in-a-selected-range-in-google-sheets/.
stats writer (2024) 'How can I count the number of non-empty cells in a selected range in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-non-empty-cells-in-a-selected-range-in-google-sheets/.
[1] stats writer, "How can I count the number of non-empty cells in a selected range in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I count the number of non-empty cells in a selected range in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.