I have created a list of numbers.... let's say from 0 to 1000

this list is coming from a database of information.
I want to find out how many numbers are available in certain intervals
0-35, 35-55, 55-75, 75-95, and then the intervals increase in size after 300.

I have an excel list holding this data.... (from the Data MenuListCreate
List)

now it is easy to use the custom feature with the filter of the list to get
it to show the numbers in a certain range. then count the numbers in each
range and put the info in a separate table

What i would like to do and i am not sure if this is possible, is create a
reference
to the custom filter of the list
for example

Range Count
------- -------
0-35 =count(list.customrange(0<x<35)
35-55 =count(list.customrange(35<x<55)

and so forth and so on...

I do not know if you can use a list reference in a count function and i do
not know if there is such a reference. Any help would be appreciated.