Excel Forum
Similar Content
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
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...

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.