Search a cell and count

K

Kellia

I have cells with various amounts of numbers in them. For example, d6 has
{0, 3, 6, 9} while d9 has {1, 3, 4, 7}. I'd like to count the number of
times the numbers 1, 3 and 4 appear in each cell...
 
M

Marcelo

one way.

text to column delimited by comma, countif(a2:a1000,2)

--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Kellia" escreveu:
 
Top