For each cell in the column I need to get the number of cells in the column that are in the range of the value of the cell and the value + 10. I tried COUNtIF
Let's say this is the column:
11 -> how many cells between 11 and 20
23 -> how many cells between 34 and 43
17 -> how many cells between 17 and 27
13
26
Tried this but it only displays zeros:
=COUNTIFS(B:B; ">=B2"; B:B; "<B2+10")