SOLVED

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

Copper Contributor

# 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

4 Replies

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

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

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

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

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

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

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

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

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

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

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