i-nth logo
Use COUNTIFS, not FREQUENCY, to calculate frequency distribution tables for charting histograms
27 April 2013

Excel's FREQUENCY function was first created to calculate frequency distribution tables, which are needed for charting histograms. But the COUNTIFS function offers more power, and it's easier to use.

Full article: Use COUNTIFS, not FREQUENCY, to calculate frequency distribution tables for charting histograms