Answer the question
In order to leave comments, you need to log in
How to count how many times a number occurs in an array?
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ...
I count how many times the number "12" occurs in the array. The formula shows zero:
=COUNTIF(M9:M22, "12")
Please tell me what I'm doing wrong? The array is derived by another formula, maybe that's the issue?
And also you will need to count how many times zero occurs, but do not take into account if it is 10 and 20.
Answer the question
In order to leave comments, you need to log in
"12" is text and 12 is a number.
=СЧЁТЕСЛИ(M9:M22; 12)
but don't count if it's 10 and 20.
=filter(filter(A:A;A:A<>10);filter(A:A;A:A<>10)<>20)
it will be necessary to count how many times zero occurs
=ArrayFormula(СЧЁТ((1+split(join("";filter(filter(A:A;A:A<>10);filter(A:A;A:A<>10)<>20));"0";1;0))))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question