Excel Forum



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.