Forum Discussion

patel_dipesh's avatar
patel_dipesh
Copper Contributor
Dec 13, 2022
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  
Formulas and Functions
  • patel_dipesh's avatar
    patel_dipesh
    Dec 13, 2022
    but it except the same numer as 15 ,15 it count 1 number only
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 13, 2022

patel_dipesh 

As variant

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

Resources