Hello All,


Happy New Year!!!


First time in a cite like this. I have been reading some of the posts and love all the help folks are willing to give.



I am looking to add digits that appear in a column and don't seem to understand how to do the array properly.

Let's say I have column L and have information in L10 - L287. I have the following numbers in the columns,

L105 2, 3, 7, 12, 17
L106 3, 5, 8, 11, 12
L107 4, 5, 6, 14, 17

Say that I simply want to count how many times each number appears. In putting in formula's and trying to find out how may times JUST 7 appears, NOT 17, it does not work. It counts the 7 as well as the 17 and gives me a value of 3 times. I would like to be able to have it tell me there is one 7 and two 17's.

The formula I have used is this: =SUM(LEN(L105:L287)-LEN(SUBSTITUTE(L105:L287,"7","")))/LEN("7")

If I do the same formula and use 17, it will pick out just the 17's.

The formula works for double digits but not for single digits?

Clearly I don't understand how this is done. Sorry. I am not the brightest bulb on the tree.

Anyone know how I can do that?

Thank you in advance for any assistance. Have a great evening.

I love groups like this. Makes you realize people are good.