I have a Column of numbers spread from 0 -100. I would like to count the number in a category such as the total number of 50-59, 60-69 etc.
How do I use multiple range selection for countif?
Having same issue. Here’s the video: http://youtu.be/SKKmlSENNLM and here’s the spreadsheet: https://plus.google.com/116948076340592829238/posts/6dDtKuEebNm
Sounds like the FREQUENCY function would be your friend, entered as matrix/array function (close with Shift+Ctrl+Enter instead of just Enter).