Forum Discussion
Count function
How can i count the number of characters in a range of cells. What i am trying to do is figure out as an example how many #1's , #2's and so forth are in a range of cells. So i know how many of each # i need to purchase to number team uniforms.
2 Replies
Peter_Potteiger The trick is to create on long string of all numbers. Then split it in individual digits and then count all digits (0-9). In newer versions of Excel you can use TEXTJOIN and SEQUENCE to achieve this relatively easily. In older Excel versions that do not support the CONCAT function, you have to do a bit extra work to create the initial string of numbers. I have demonstrated all of these in the attached file. If your Excel version does not support a method, you'll notice it immediately. The result of the count is in columns G and H.
Peter_Potteiger Hi,
Please find attached file for your further consideration.
=COUNTIF($C$1#,F2)
Simply, you may use above written formula.
