COUNTIF function - Function that counts the number of cells in a data table that meet certain conditions in Excel
The following article introduces you to the COUNTIF function - one of the functions in the statistical function group is very popular in Excel.
Description: The function does a count of cells in a data table that meet certain conditions.
Syntax: COUNTIF (range, criteria)
Inside:
- range: Range you want to count, is a required parameter.
- criteria: The condition that identifies a cell or reference to be counted, which is a required parameter.
Attention:
- For conditional strings longer than 255 characters -> the function returns the wrong value.
- When the function refers to a closed cell or sheet -> the function returns the #VALUE! Error value
- For data that is text, enter a value without leading spaces.
For example:
Calculate the total number of items described in the table below:
1. Calculating the total number of items with unit price of 25000.
- In the cell to calculate, enter the formula : = COUNTIF (D6: D10, "= 25000")
- Press Enter -> item number with unit price of 25000 is:
2. Calculate the total number of items as apples.
- In the cell to calculate enter the formula: = COUNTIF (C6: C10, "= Apple *")
- Press Enter -> total number of apple items in the data table is:
3. Calculate the total number of fruit products except apples.
- In the cell to calculate, enter the formula: = COUNTIF (C6: C10, "<> Apple *")
- Press Enter -> total number of fruit items except apples is:
Above are instructions and some specific examples when using the COUNTIF function in Excel.
Good luck!
You should read it
- How to use COUNTIF function on Excel
- How to use Hlookup function on Excel
- The COUNTA function, how to use the function to count cells containing data in Excel
- How to compare data on 2 Excel columns
- COUNT function - Function that counts cells containing numbers in the list of arguments in Excel
- How to use the DAVERAGE function in Excel
- Instructions on how to use the Dmax function in Excel
- How to use DCOUNT function on Excel
May be interested
- DCOUNT function in Excel - Usage and practical examplesthe dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
- How to use AVERAGEIF function in Excelaverageif function on excel is a conditional plus average function in the data table, with the given conditions set by the user.
- AVERAGEIFS function - The function returns the average of the arguments that meet multiple conditions in Excelaverageifs function: the function returns the average of the arguments that meet multiple conditions. syntax: averageifs (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- DCOUNTA function, how to use the function to count non-empty cells in Exceldcounta functions in excel to count non-empty cells in database fields or lists according to specific conditions.
- Instructions for using the COUNTBLANK function in Excelin excel, the countblank function helps users count the number of blank cells in a given data range. this function is useful in checking for missing data, processing reports and statistics. this article will guide you in detail on how to use countblank, with practical examples.
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
- Merge cells in Excelthe most common reason to merge cells is to format and center headers. this tutorial will show you how to merge cells in excel, although you shouldn't merge them unless you really need to.
- How to use MAXIFS function in Excel 2016maxifs function in excel is a statistical function that returns the largest value based on one or more conditions from the specified cells. maxifs function was introduced in ms excel 2016.
- How to automatically create valuable cell borders in Excelthere are many ways of highlighting valuable cells in excel, such as creating borders for cells automatically when entering values.
- COUNTA function in Excel, function to count cells containing data with specific usage and examplesthe counta function in excel is a useful data statistics function. below are details on how to use the function to count cells with data in excel.