Excel Forum



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.