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