Forum Discussion
Solved
in column there are number and i want to total them in cell
33
33
30
29
15
12
i want to total number occurrences below 32 how to calculate include repeted numbers
- but it except the same numer as 15 ,15 it count 1 number only
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")
- but it except the same numer as 15 ,15 it count 1 number only
Let's say the numbers are in A1:A10. You could use:
=LET(a,A1:A10,filtered,FILTER(a,a<32),COUNT(UNIQUE(filtered)))
