If I understand you correctly, check out the FREQUENCY() function in XL
Help.

In article ,
Huidekoper wrote:

I want to organise data from a serie to classes (< -1, -1 to 0, etc.), so
that I can make a chart. Does anybody knows if there is a function for that?