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...
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...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...



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.