Excel -- frequency distribution

Experts:

I need some assistance with counting frequencies for a frequency distribution table.   Please see attached XLS.

The count of 25 records should not change.    However, what may change is the value for the lower limit and the class interval.

Any ideas for a function that will automate the frequency distribution?

Thank you,
EEH
Frequency-Distribution.xlsx
ExpExchHelpAsked:
Who is Participating?
 
Saurabh Singh TeotiaCommented:
Use this formula..

=SUMPRODUCT(($C$7:$C$31>=F6)*($C$7:$C$31<=G6))

Open in new window


Or Option-2

=COUNTIFS($C$7:$C$31,">="&F6,$C$7:$C$31,"<="&G6)

Open in new window


Enclosed is the file for your reference...

Saurabh...
Frequency-Distribution.xlsx
0
 
ExpExchHelpAuthor Commented:
PERFECT SOLUTION!!!!!!!!!!   Thanks, EEH
0
 
Rodney EndrigaData AnalystCommented:
=COUNTIF($C$7:$C$31,F6)+COUNTIF($C$7:$C$31,G6)

Open in new window


You can use a formula like this in cell H6 and copy down.
0
 
Rodney EndrigaData AnalystCommented:
Saurabh is fast! Nice solution too... I should REFRESH before I post :D
0
 
Saurabh Singh TeotiaCommented:
Its okay Rodney..Happens with all of us.. :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.