Excel Countif - Free Excel Tutorial

Running Count of Occurrence List

This post will guide you how to get running count of an occurrence in a list with formula in Excel 2013/2016 or Excel office 365. How to create a running count of certain values that appear in the given range of cells in your worksheet in Excel. Running Count of Occurrence in List Assuming you… read more »

Count Non-Contiguous Range using COUNTIF

This post will guide you how to count a non-contiguous range with criteria in COUNTIF function in Excel 2013/2016 or Excel office 365. How do I build a formula for counting non-contiguous range in Excel using COUNTIF function in Excel. What is Non-Contiguous Range? A non-contiguous range consists of tow of more separate ranges in… read more »

How to Count Unique Numeric Values in a Range in Excel

This post will guide you how to count unique numeric values in the given range in Excel 2013/2016 or Excel office 365. How do I count the unique numeric values in a list of data with some duplicate values using a formula in Excel. And you can use a formula that uses the SUM function… read more »

How to Count Unique Dates in Excel

This post will guide you how to count unique dates in a given range in Excel 2013/2016 or Excel office 365. How do I count the unique dates in a list of dates with some duplicate dates using a formula in Excel. And you can do this by a formula based on the SUMPRODUCT function… read more »

How to Count Total Matches in Two Ranges in Excel

This post will guide you how to count total matches in two given ranges in Excel 2013/2016 or Excel office 365. How do I count compare two ranges and count total matches between two given ranges in Excel.And you can do this by a formula based on the SUMPRODUCT  function and the COUNTIF function in… read more »

How to Count Occurrences in Entire Workbook in Excel

This post will guide you how to count number of occurrences in whole workbook in Excel 2013/2016 or Excel office 365. How do I count how many times a string is repeated in all worksheets in Excel. You may be want to count occurrences for the number of times a certain value matches across all… read more »

How to Count Specific Items in List in Excel

This post will guide you how to Count Cells that contain a apecific string of text using a formula in Excel 2013/2016 or Excel office 365.How do I create a count of the values that appear in a list or table in Excel. And this post will show you how to use the COUNTIFS function… read more »

How to Count the Cells that Match Two Criteria in Excel

This post will guide you how to Count Cells that match two or more criteria in the range of dates using a formula in Excel 2013/2016 or Excel office 365.How do I count on two or multiple criteria or you want to count something in a range of cells only if two or three conditions… read more »

How to Count Cells that do not Contain Specific Text in Excel

In the previous post, we talked that how to count cell that contain certain text using the COUNTIF function in Excel. This post will guide you how to count the number of cells that do not contain specific text within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How… read more »

How to Count Cells that Contain Specific Text in Excel

This post will guide you how to count the number of cells that specific text within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How do I count the number of cells with certain text using a simple formula in Excel. When you analyze a large list of data,… read more »

How to Count Cells that Contain Text in Excel

This post will guide you how to count the number of cells that text only within a range of cells using a formula in Excel 2013/2016 or Excel office 365. How do I count the number of cells with text values(not errors, not numbers, not blanks) using a simple formula in Excel. When you analyze… read more »

How to Count Cells that Contain negative Numbers in Excel

This post will guide you how to count the number of cells that contain negative numbers within a range of cells using a formula in Excel 2013/2016.You can count the number of negative numbers in your data using easy functions in Excel. And the below will show you two ways in which you can count… read more »

How to Count Number of Cells that Contain Errors in Excel

This post will guide you how to count the number of cells that contain errors within a range of cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells contain errors in… read more »

How to Count Cells Are Not Blank or Empty in Excel

This post will guide you how to count cells that are not blank or empty in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are not blank in a particular range with a VBA macro in Excel. You should know that excel offers several count… read more »

How to Count Blank or Empty Cells in Excel

This post will guide you how to count blank or empty cells in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are blank in Excel. You should know that excel offers several count functions to count the number of cells in a selected range of… read more »

How to Count Cells That Begin with Specific Text in Excel

This post will guide you how to count cells that begin with a specific text string in a given range cells using a formula in Excel 2013/2016.How do I count cells the number of cells that begin with a certain text string in Excel. Count Cells that Begin with Specific Text Assuming that you want… read more »

How to Count Cells Not Equal to One of Many Things in Excel

This post will guide you how to count the number of cells that are not equal to many things in a given range cells using a formula in Excel 2013/2016. You can easily to count cells not equal to a specific value through COUNTIF function. But if there is an easy way to count cells… read more »

Sidebar