## 'Count' category

Count cells with text

Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]

Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]

Count rows containing data

Table of Contents Count rows with data Count non-empty rows Count cells between two values Count cells based on a […]

Table of Contents Count rows with data Count non-empty rows Count cells between two values Count cells based on a […]

Count cells containing text from list

The array formula in cell F3 counts cells in column B that contains at least one of the values in […]

The array formula in cell F3 counts cells in column B that contains at least one of the values in […]

How to use the COUNTIF function to count not blank cells

The COUNTIF function is very capable of counting non-empty values, I will show you how in this article. Excel can […]

The COUNTIF function is very capable of counting non-empty values, I will show you how in this article. Excel can […]

Count specific multiple text strings in a given cell range

This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range.Â The […]

This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range.Â The […]

Count a specific text string in a cell

Table of Contents Count a specific text string in a cell Count text string in a range (case sensitive) Count […]

Table of Contents Count a specific text string in a cell Count text string in a range (case sensitive) Count […]

Count how many times a string exists in a cell range (case insensitive)

Question: How do I count how many times a word exists in a range of cells? It does not have […]

Question: How do I count how many times a word exists in a range of cells? It does not have […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values