Frequency Formula In Excel
Link to full course: https://commercecurve.com/ultimate-ex...
Take this course if you're looking to accelerate your career with a complete course that integrates finance and accounting topics with end-to-end Excel training through the application of concrete examples of real world companies.
The FREQUENCY formula in excel is used to count the number of times an item appears in an array. It is useful to count the number of times a numerical value appears in a range. An alternative to this is to use a COUNTIFS function.
=FREQUENCY(data_array, bins_array)
data_array: This is an array of data where we want count frequencies. Note that blanks and text are ignored.
bin_array: This is an array of data where we want to group the values in data_array.