I have a spreadsheet that is looking at individual cells and counting specific values that have been entered in them. For example: Cell G2 has 1,1,3,11,7,1 entered in it. I need another cell to count only the "1"s. However, it views 11 as two 1s as well so my result shows 5 when it should be 3. Here is my formula I'm using.
=SUM(LEN(G2)-LEN(SUBSTITUTE(G2,"1","")))/LEN("1")
Bookmarks