# COUNTIF Articles: Excel and Google Sheets

All resources related to COUNTIF for Excel and Google Sheets.

### 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...