How to Count Cells That Contain Specific Text in Excel

In this article, we will learn How to Count Cells That Contain Specific Text in Excel. What is COUNTIFS with criteria ? In simple words, whi...

How to COUNTIFS With OR For Multiple Criteria in Excel

Basically, when we supply multiple conditions to a COUNTIFS function, it checks all the conditions and returns row which matches all the conditions. W...

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

How to Count unique entries in a range using COUNTIF function in Excel

In this article, we will learn How to Count unique entries in a range using COUNTIF function in Excel .What are unique values in range ? Non...

Count the number of cells in a range containing all types of Errors in Microsoft Excel

In this article, we will learn counting the number of cells in a range containing all types of errors in Microsoft Excel. We will use ISERROR  functi...

Count the Number of Values between a Lower and Upper Limit in Microsoft Excel

In this article, we will learn how to count the number of values between a lower and upper limit. We will use “SUMPRODUCT” function in Microsoft E...

Counting the Number Of Yes Responses in a Student Questionnaire in Excel 2010

In this article, we will learn how to count the number of yes responses in a student questionnaire. To count the number of Yes responses in a stude...

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.