If you have a few frequencies to determine, look a the Countif function. If you
have many, you're probably better off creating a pivot table. Post back if
you're having trouble with either of these.
Fred has the right idea. Pivot tables are the best way to summarize this
type of data. They can summarize with several different functions and the
results can easily be converted to percentages or percentiles
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.
