to group in small range, and count
 

I have a group of years, and I want to group in range, and then I want to
excel count the numbers that belongs to each range. How I do it?

to group in small range, and count
 

Hi Carolina,
You could use Data, Subtotal

http://www.datapigtechnologies.com/ExcelMain.htm
see Basics fo Subtotals
the link there is a Flash 8 presentation

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Carolina" wrote in message ...
I have a group of years, and I want to group in range, and then I want to
excel count the numbers that belongs to each range. How I do it?