A
A
Alina Shah2021-08-23 22:06:08
Google Sheets
Alina Shah, 2021-08-23 22:06:08

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

1 answer(s)
G
Grigory Boev, 2021-08-24
@Shah_Alina

"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 question

Ask a Question

731 491 924 answers to any question