Excel Forum
Similar Content
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...
Formula to Count Occurrence of Specific Characters in a Cell
Tutorial: Formula that counts the occurrences of a specific character in a cell in Excel. This tutor...
Count the Number of Unique Values in a List in Excel
Tutorial: Use a formula to count the number of unique values that are contained within a list in Exc...



Excel Array Formula Series #9: Count Characters in Range


See how to create array formula that counts all the characters in a range of cells

The formula SUM(LEN(B26:C46)) counts all the characters in a range of cells. Don't forget Ctrl + Shift + Enter

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.