COUNTIF Articles: Excel and Google Sheets

Excel's COUNTIF function is used to count cells in a selected range that meet a single criterion. It can be used to count cells with numbers, texts, and dates that match your specifications. The function supports a variety of operators as well as partial matches and wildcards.  Whether you want...

In what situations would you need to count distinct values in a column? While working on data, many times we come across a case where we have a data set that contains duplicate values, and we want to know that how many values are distinct there. In small data set...

Do you have a group of data in Excel and need to find the number of cells that are greater than a particular number? If so, you can use the COUNTIF function for this purpose.  Use COUNTIF to figure cells greater than some chosen figure The COUNTIF function counts the...

The usage of the COUNTIF & Conditional Formatting functions in Excel can yield useful and visually appealing results. This step by step tutorial will assist all levels of Excel users in creating dynamic conditional formats. Our data-set shows the date and the type of vehicle rented. Now, we want to...

Excel COUNTIF function counts the number of cells in a range that meet specified condition in a range. It is combination of IF and COUNT functions. IF part specifies condition or criteria to check each cell in range and COUNT gives total of those cells which meet that criteria or...

The COUNTIF function in Google Sheets is used to count the number of times a value is found in a selected data range that meets the specified criteria. It is basically a combination of the IF function and COUNT function. Using the COUNTIF function in Google Sheets The COUNTIF function...

Sometimes you have a set of data in Excel that contains some blank cells. You can use the COUNTA function to create a formula that will only count the cells that are not blank. COUNTA to Count Cells that are Not Blank Let’s say you want to count cells that...

You use the COUNTIF function in Excel when you want to count cells based on a single criterion. If you want to count based on multiple criteria, you will use the COUNTIFS function. Here is how to make the best use of this function.  Using COUNTIF with multiple criteria Syntax...

Using the COUNTIFS function you can achieve the result of counting numbers of cells which contain values between two numbers in a range. Using the COUNTIFS Function Between Two Values The COUNTIFS function can show the count of cells that meet your criteria. You can use COUNTIF with criteria using dates,...