in column there are number and i want to total them in cell

[patel_dipesh]

33

33

30

29

15

12

i want to total number occurrences below 32 how to calculate include repeted numbers

[#2]

Hi @patel_dipesh 

You would use countif function, the following formula will count the cell in the range A1:A5 that its value less than 32.

=COUNTIF(A1:A5,"<32")

[#3 · Accepted solution]

but it except the same numer as 15 ,15 it count 1 number only

[#4]

@patel_dipesh 

Let's say the numbers are in A1:A10.  You could use:

=LET(a,A1:A10,filtered,FILTER(a,a<32),COUNT(UNIQUE(filtered)))

[#5]

@patel_dipesh 

As variant

=SUM( (A1:A10 < 32) / COUNTIF(A1:A10,A1:A10) )