Posts Tagged 'Excel CountIf'
Excel COUNTIF and COUNTIFS with OR conditions
As everyone knows, Excel COUNTIF function is designed to count cells based on just one criterion while COUNTIFS evaluates multiple criteria with AND logic. But what if your task requires OR logic – when several conditions are provided, any one can match to be included in the count? Continue reading
Excel: If cell contains then count, sum, highlight, copy or delete
In our previous tutorial, we were looking at Excel If contains formulas that return some value to another column if the target cell contains a specific value. Aside from that, what else can you do if a cell contains certain text or number? Continue reading
How to count words in Excel
Excel doesn't provide any function or built-in tool for counting the number of words in a cell or range. Luckily, we can combine serval functions within a formula to get the desired result. In this tutorial, you will find a few useful formulas to count total or specific words in a cell or range. Continue reading
How to count characters in Excel: total or only specific characters in a cell / range
The tutorial explains how to count characters in Excel. You will learn the formulas to get the total character count in a range, and count only specific characters in a cell or in several cells. Continue reading
How to count distinct and unique values in Excel
In this tutorial, you will learn how to count unique values in Excel with formulas, and how to get an automatic count of distinct values in a pivot table. We will also discuss a number of formula examples for counting unique names, texts, numbers, cased-sensitive unique values, and more. Continue reading
Excel COUNT and COUNTA functions to count cells
This short tutorial explains the basics of the Excel COUNT and COUNTA functions and shows a few examples of using a count formula in Excel. You will also learn how to use the COUNTIF and COUNTIFS functions to count cells that meet one or more criteria. Continue reading
How to find duplicates in Excel: identify, highlight count, filter, and more
The tutorial explains how to search for duplicates in Excel. You will learn a few formulas to identify duplicate values or find duplicate rows with or without first occurrences. You will also learn how to count instances of each duplicate record individually and find the total number of dupes in a column, how to filter duplicates, and more. Continue reading
How to compare two columns in Excel for matches and differences
The tutorial demonstrates a number of techniques to compare and match two or more columns in Excel with formulas, conditional formatting and the specialized wizard. Continue reading
How to count cells with text and characters in Excel
This tutorial shows how to count cells with text and characters in Excel 2010-2013. You will find several helpful Excel formulas for counting characters in one or several cells, character limits for cells and get a link to see how to get the number of cells that contain specific text. Continue reading
How to use Excel COUNTIFS and COUNTIF with multiple criteria
The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading
COUNTIF in Excel - count if not blank, greater than, duplicate or unique
The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading
