lepium
Much easier than countif, there's a macro built - into Excel for this stuff. Have you installed the Data Analysis tools? They do come with MS Excel but I recall you had to choose to have them installed at some point.
Anyway, check the attached document. After you've added the data analysis tools, choose Data analysis in the Tools menu and then input the same data I have in this example, and... voilá!
Cheers. L.
L -
Thanks for the screen shot -- that's (almost)exactly what I did! And yes, I did have to install the data analysis tools.
The one difference is that for the cell range for the bins, I had to choose C4:C12, because if I chose C5, my frequency table looked like this:
604 Frequency
614 6
624 3
634 3
644 9
654 1
664 1
674 0
More 1
Where you can see that 604 is in line with the frequency heading, rather than down a row.
When you do it your way, how many total data points do you get in your frequency table? As you can see, I am only getting 24 above. Poor pittsburgh, my excel just won't count it.