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