Excel Forum
Similar Content
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Average Non-Contiguous Cells in Excel
Tutorial: How to average non-contiguous cells (cells that aren't next to each other) if those cells...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...

Mr Excel & excelisfun Trick 15: Frequency Distribution

See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create a Frequency Distribution and use the SUMPRODUCT, COUNTIFS, and COUNTIF functions (upper limit is not included in count) to create a Frequency Distribution.

Got a Question? Ask it Here in the Forum.