Excel Functions You Need to Know: Counting and Conditional Counting
Part IIb of a comprehensive series on Excel functions.
Welcome to Part II of the Excel Functions Demystified series, where we’ll begin coverage of Statistical Function in Excel. There are quite a few statistical functions available in Excel, so this will be split into 8 subparts:
- Measures of Center
- Counting and Conditional Counting
- Probability Distributions pt.1
- Probability Distributions pt.2
- Probability Distributions pt.3
- Regression and Correlation
- Statistical Tests
- Miscellaneous Statistical Functions pt.1
- Miscellaneous Statistical Functions pt.2
This article covers subpart 2: Counting and Conditional Counting. Excel has a variety of built-in functions to describe the number of points in a dataset:
1. COUNT Function:
The COUNT function is used to count the number of cells in a range that contain numeric values. The syntax of the COUNT Function is:
=COUNT(value1, [value2], …)
Where value1, value2, etc. are the values or cell references that you want to count.
2. COUNTA Function:
The COUNTA function is used to count the number of cells in a range that contain any type of data, including text, numbers, and logical values. It is particularly useful when working with data that contains a mix of different data types. The syntax of the COUNTA Function is:
=COUNTA(value1, [value2], …)
Where value1, value2, etc. are the values or cell references that you want to count.
3. COUNTBLANK Function:
The COUNTBLANK function is used to count the number of blank cells in a range. It is particularly useful when working with data that contains missing values. The syntax for the COUNTBLANK Function is:
=COUNTBLANK(range)
Where range is where to count blank cells from.
4. COUNTIF Function:
The COUNTIF function is used to count the number of cells in a range that meet a specific criteria. It allows users to count cells based on a single condition. The syntax for the COUNTIF Function is:
=COUNTIF(range, criteria)
Where range is the cells to count, and criteria is the condition that must be true to count the cell.
5. COUNTIFS Function:
The COUNTIFS function is used to count the number of cells in a range that meet multiple criteria. It allows users to count cells based on multiple conditions. The syntax for the COUNTIFS function is:
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Where criteria_range1 is the range of cells that you want to evaluate for the first criteria, criteria1 is the condition that you want to test for in criteria_range1, and so on.
Thank you for reading this article!
For 1:1 excel tutoring, please inquire at: ghdatascience001@gmail.com.
Subscribe to follow along: https://medium.com/@georgehennen/subscribe.
