If you're using the worksheet FREQUENCY function (instead of the easier
Tools | Data Analysis | Histogram feature), it must be "array entered." That
is, select the range of cells that will contain the function, type the
function, but don't press Enter. Instead, after typing the function, hold
down Control and Shift while you press Enter, thus "array entering" the
function.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.