Excel Countif

How to Sort a Column by Occurrence Count in Excel

This post will guide you how to sort a column by occurrence count in Excel. How do I sort data in one column by the most frequent value in Excel 2013/2016. Sort A Column by Occurrence Count Assuming that you have a list of data in one column, and you want to sort this column… read more »

How to Count or Sum Cells with Checked Box in Excel

This post will guide you how to count the number of checked checkboxes in your worksheet in Excel. How do I Count or sum all cells with checked boxes with a formula in Excel. Count or Sum Cells with Checked Box Assuming that you have a list of data in range A1:C5, in which contain… read more »

How to Count the Number of Cells with non-zero value in Excel

This post will guide you how to count the number of cells with non-zero value with formula in Excel 2013/2016. Count the Number of Cells with non-zero value Assuming that you have a list of data in range A1:C6 which contain text string values. And you want to count the number of cells with non-zero… read more »

How to Count Unique Values in Excel

This post will guide you how to count unique values or distinct values with a formula in Excel. How do I Count unique values or numbers in a given range in Excel. Count Unique Values Using Advanced Filter Count Unique Values Using Formula Assuming that you have a list of data that you want to… read more »

How to Rank Numbers without Repetitive Ranks in Excel

This post will guide you how to rank range numbers with unique ranking in Excel. How do I use Rank function to get the unique ranking of values for a range with duplicate values in Excel 2013/ 2016. Ranking without Repetitive Ranks Assuming that you try to use the RANK function to sort values in… read more »

How to Extract a Unique List based on Criteria in Excel

This post will guide you how to extract unique values in a range based on one criteria with a formula in Excel. How do I create a unique distinct list based on one condition in Excel. Extract Unique List of Values based on Criteria Assuming that you have a list of data in range A1:C6,… read more »

How to Count Cells That Contain Specific Text in Excel

This post will guide you how to count cells that contain specific text in Excel. How do I count cells with text and characters using a formula in Excel. How to count cells with specific text value using VBA Macro in Excel. Count Cells with Specific Text using Formula Count Cells with Specific Text using… read more »

How to Extract a Unique Distinct List from a Column in Excel

This post will guide you how to extract a unique distinct list from two or more columns in Excel. How do I get a list of distinct values in multiple columns with a formula in Excel. How to create a list of unique values from a range of cells using VBA Code in Excel. Extract… read more »

How to Average a Range and Ignore Zero in Excel

This post will guide you how to average a range of cells and ignoring all zero values in Excel. How do I Average numbers in a given range and ignore zero values with a formula in Excel. How to ignore zero when averaging a range of data in Excel. Average a Range and Ignore zero… read more »

Sidebar