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