# COUNT Articles: Excel and Google Sheets

All resources related to COUNT for Excel and Google Sheets.

### COUNT

Summary count of non-blank categories
Excel allows a user to create a summary count of non-blank categories using the COUNTIFS function. This step by step tutorial will assist all levels of Excel users in creating a summary count of non-blank categories. Figure 1. The result of the COUNTIFS function Syntax of the COUNTIFS Formula The...
How to Count Text in Excel
Microsoft Word allows you count text, but what about Excel? If you need a count of your text in Excel, you can get this by using the COUNTIF function and then a combination of other functions depending on your desired result.  How to count text in Excel If you want...
How to Count Characters in Excel
After this tutorial you will be able to count total characters in a cell or range, occurrences of specific character or character combination in a cell or range with both case sensitive and insensitive alternatives. Knowledge gained in this tutorial is a really good base for further creative Excel problem-solving. How...
How to Count Words in Excel
Excel has built-in functions to count cells based on various condition(s). These include cells containing specific values like numbers, text, blank or non-blank values, and to calculate the length of a string. But unfortunately, there is no special built-in function to count words in Excel. This is possible, however, with...
How to Count Unique and Distinct Values in Excel
Working with large data sets, we often require the count of unique and distinct values in Excel. Though this may be required in many cases, Excel does not have any pre-defined formula to count unique and distinct values. In this tutorial, you will see a few techniques to count unique...
How to Count Duplicate Values in Excel
Working with large data sets often requires you to count duplicates in Excel. You can count duplicate values using the COUNTIF function. In this tutorial, you will learn how to count duplicates using this function. How to Count Duplicates in Excel You can count duplicates using the COUNTIF formula in...
How to Use the Count Function in Google Sheets
The COUNT formula in Google Sheets extracts the number of time a numeric value exists in a range. COUNT is one of the simplest and most used formulas in Google Sheets. In this tutorial, you will learn how to use the COUNT function in Google Sheets. Using the COUNT function...
How to Count Colored or Highlighted Cells in Excel
The COUNT function in Excel counts cells containing numbers in Excel. You cannot count colored or highlighted cells with the COUNT function. But you can follow a few workarounds to count colored cells in Excel. In this tutorial, you will learn how to count colored cells in Excel. In excel,...
How to Count Blank or Empty Cells in Excel
Excel provides numerous methods to count blank or empty cells in a selected range of cells. In this article, you need to learn how to apply these methods to count blank or empty cells in Excel. First, you need to understand the difference between Blank and empty cells. How to...
How to Count Non Blank or Non Empty Cells in Excel
When you enter data in large data sets or tables in Excel, some cells are left blank or empty due to unavailability of related data or better visualization of data cells. Later when you need count of cells where data is entered, then you need to use quick and efficient...
1 2 4 5 6