# COUNTIF-Function

## How to use Countif function with wildcards in Excel

Countif is an important function which is used to count number of cells which meet the given single condition or criteria. You can use Countif function to count number of cells which have any number, text or dates that match the given specific condition. But sometime we need to use wildcards for partial matching in the given range of cells in active worksheet. In that situation you must know how to use Countif function with wildcards in Excel Read More

## How to compare data between two lists in Excel

During working on Excel you want to check if any particular data of one column matched with another column data or not ? You can easily compare two list data in Excel using few simple tricks. In this guide we have to discuss how to compare data between two lists in Excel. Read More

## How to Identifying Duplicate Values in two Excel worksheets

If you have more than one worksheets in the same workbook and want to search duplicate values in two Excel worksheet. It is too much difficult to search duplicate values in Excel sheet. In this guide we have to discuss quick ways which helps you to identifying duplicate values in two Excel worksheet. Read More

## 3 Ways to find duplicate values on same worksheet – Excel

If is too much difficult to search duplicate values in active worksheet. In this guide we have to discuss 3 quick ways to find duplicate values on same worksheet. If you have more than one duplicate and unique records then you can easily find duplicate values on active worksheet. Read More

## How to Sum or Count cells based on background color in Excel

Suppose during working on Excel, if you get a worksheet in which there are different kind of background colors in range of cells. Now if someone ask you how to sum or count cells based on background color in Excel. It is not an easy task to get the proper answer in quick way. In this guide we have to discuss how to sum or count cells based on background colors in Excel. Read More