Could you create another column of data for 1's and 2s from the listed data?
If so, put this in it:

=MAX(INT((A2-1)/15)+1,1)

Where A2 is the cell location of the numbers you want to count.

"Metalteck" wrote:

I have a column with various numbers. I want to be able to count certain
numbers, such as 0-15,16-30, and so on.

I want to be able to write an if statetment that says if a number is between
0 and 15, count it as a 1, 16-30 counted as a 2.

Then need to perform a specific count for just 1's, 2s,....

Can you help me