Excel Forum

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

Excelisfun is conducting a FAVORITE FORMULA SURVEY! Watch the 3 different Formulas in this video and then vote in the comment section for the one you like best! See SUMPRODUCT function formula, COUNTIF function formula and a SUM & IF function formula: vote for the one you like best!! All three formulas will count quantitative data in categories that include the lower limit but not the upper limit.

For more about Counting between an upper and lower value, see this video (In this video we include lower limit and upper limit): Excel Magic Trick #175: Count Between Upper & Lower Value
To learn about the FREQUENCY function, see this video (In this video we include upper limit but not lower limit): Excel Array Formula Series #8: FREQUENCY function

Got a Question? Ask it Here in the Forum.