'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
Table of Contents Count cells containing text from list Count entries based on date and time 1. Count cells containing […]
Table of Contents Count cells containing text from list Count entries based on date and time 1. Count cells containing […]
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 (case sensitive) Count text string in a range (case […]
Table of Contents Count a specific text string in a cell (case sensitive) Count text string in a range (case […]
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