COUNTIF Articles: Excel and Google Sheets

All resources related to COUNTIF for Excel and Google Sheets.
All articles COUNTIF

COUNTIF

Excel COUNTIF Function Examples – COUNTIF Greater Than, COUNTIF Multiple Criteria
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...
Learn How to Count Unique Values in a Column
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...
Learn How to Use COUNTIF to Count Cells Greater Than Some Number
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...
Using the COUNTIF Function of Excel’s Conditional Formatting
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...
Learn How to Use COUNTIF in Excel
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...
How to Use a COUNTIF Function in Google Spreadsheets
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...
Learn How to Apply a Formula for Counting Cells that are Not Blank
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...
How to Use COUNTIF With Multiple Criteria in Excel
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...
How to Use the COUNTIF Function to Count Cells Between Two Numbers
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,...