I want to use the COUNTIF function for a cell that contains more than 1 number
for example i want to count how many number 1's there are in a selected data set, but some of my cells contain more than two numbers such as "1,4" if it is like this the countif function does not count it as containing the number 1, is there any way around this
Solved by A. J. in 22 mins