Excel CountIFS - Free Excel Tutorial

How to Statistic Pass 4 Out of 5 Rounds in a Competition by Excel Functions

Suppose you are counting the numbers of participants who are the winners in a competition. And the passing line is provided as pass 4 out of 5 rounds of games. You need to know if participant pass the game or not firstly. If you are familiar with the functions in Excel and can use them… read more »

How to Count Not Empty or Blank Cells with COUNTIFS in Excel

This post will guide you how to count not empty cells or categories with COUNTIFS function in Excel 2013/2016 or Excel office 365. You can use the COUNTIFS function to count not blank cells with a given criteria in excel. Summary Not Empty Cells with COUNTIFS Assuming you have a dataset in range A1:C6, and… read more »

How to Create a Summary Count by Month with COUNTIFS in Excel

This post will guide you how to create a summary count by month with COUNTIFS function in Excel 2013/2016 or Excel office 365. You can use the COUNTIF function to count cells with a given criteria in excel. this guide will show you the simple formula used to create a summary count by month with… read more »

How to Use COUNTIFS function with Multiple Criteria and OR Logic in Excel

This post will guide you how to Use COUNTIFS function with multiple criteria and OR logic in Excel 2013/2016 or Excel office 365. How to count with multiple criteria and OR logic in Excel. COUNTIFS with Multiple Criteria and OR Logic Normally, when you provide multiple conditions to a COUNTIFS function, and it will check… read more »

How to Count Number by Range with COUNTIFS Function in Excel

This post will guide you how to Count Number by Range with COUNTIFS function in Excel 2013/2016 or Excel office 365. How do I count the number of values that fall with in a specified range by using the COUNTIFS function in Excel. And you should know that the COUNTIFS function can be used to… 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 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 Not equal to X or Y in Excel

This post will guide you how to count the number of cells not equal to criteria X or Y in a given range cells using a formula in Excel 2013/2016.You can easily to count cells equal to or not equal to a specific value through COUNTIF function. But if there is an easy way to… 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 »

How to Count Cells between Two Numbers in Excel

This post will guide you how to count cells between two numbers using a formula in Excel 2013/2016. How do I count times between a given range cells based on a condition in Excel. Is there a easy way to count cells between two given numbers in a selected range of cells in Excel. Count… read more »

How to Count Cells between Two Dates or Times in Excel

This post will guide you how to count cells between two dates using a formula in Excel 2013/2016. How do I count times between a given time or date range based on a condition in Excel. Is there a easy way to count cells between two given dates in a selected range of cells in… read more »

Count Dates in Given Year/Month/Day in Excel

This post will guide you how to count dates in a give year or month or day with a formula in Excel. How do I count cells based on year, month or day in Excel. How to countif by a specified date (Year or month) in a range of cells in Excel. Count Dates in… read more »

COUNTIF with Multiple Criteria

This post will guide you how to countif multiple criteria on the same column in excel. How do I countif multiple criteria on the different columns in excel. How to use COUNTIF to count cells that match multiple criteria on the same column or the different columns in Excel. COUNTIF with Multiple Criteria in the… read more »

Rank values in a column based a specific value in another column

This post will guide you how to rank values in a column based on a specific value in another column in excel. How do I rank values in a range by a specific value in another column in excel. Rank Values Based on a Specific Value Assuming that you have a list of data contains… read more »

Highlight Duplicate Rows

This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a specific character in a specified column. And this post will talk that how to highlight… read more »

Excel COUNTIFS function

This post will teach you how to use Excel COUNTIFS function with syntax and examples in Microsoft excel. Description The Excel COUNTIFS function returns the count of cells in a range that meet one or more criteria. It allows to use the criteria with the numeric value or text string, which may be contain the… read more »

Sidebar