SOLVED

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

Copper Contributor

33

33

30

29

15

12

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

 

4 Replies

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

best response confirmed by patel_dipesh (Copper Contributor)
Solution
but it except the same numer as 15 ,15 it count 1 number only

@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)))

Patrick2788_0-1670950087029.png

 

@patel_dipesh 

As variant

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

Accepted Solutions
best response confirmed by patel_dipesh (Copper Contributor)
Solution
but it except the same numer as 15 ,15 it count 1 number only

View solution in original post