Excel COUNTBLANK Function.

To count blank cells, Excel provides COUNTBLANK function. Sure there are other makeshifts to count blank cells in excel. But why use them when we have...

Count Cells That Contain Specific Text

So, the objective is count every cell that contains a specific text. Right? Thats no big deal. We can just use COUNTIF function to count cells that co...

COUNTIFS With OR For Multiple Criteria

Basically, when we supply multiple conditions to a COUNTIFS formula checks all the conditions and returns row which match all the conditions. Which me...

COUNTIFS Two Criteria Match

We want to count something in range only if two conditions match in excel. Here we can use Excel’s COUNTIFS function. COUNTIFS function can count on...

Excel COUNTA Function

In this article, we will learn about how to use the COUNTA function in Excel. COUNTA function is a built in Excel function to calculate the Count ...

The OFFSET Function in Excel

Syntax of OFFSET =OFFSET(reference,rows, columns, [height], [width]) The OFFSET function returns reference of cell from given offset (row and column...

Count Unique Values In Excel

We will use SUMPRODUCT and COUNTIF function to count unique values in a range. Generic Formula to Count Unique Values: =SUMPRODUCT(1/COUNTIF(range...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube