Create a Frequency Distribution Table in Excel

Create a frequency distribution table in Excel with the COUNTIFS function.

This brilliant Excel function handles this task very easy.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[pritishgrover]

9 Years later, and still best and simplest video out on youtube to get class intervals done quickly. Thanks Mate!!

[kaymarjoh]

Excellent video. 7 years later you made my day a whole lot easier :)

[rgeor]

10 years late, and it still works! thank you

[starsrhigh]

Thanks a lot for the info, very easy way of constructing a table.

[johnepock]

Thank you, my friend! This video helped me in my Statistics Math Course.

[NotRealLife]

I love you you saved my life literally the amount of time I spent trying to count the data set

[tnlpokj]

Pretty easy steps. Helped me a lot when I was about to give on the test😄
Thank you for making my life easy🙂

[iwasboredonedayagain]

Looking for a video that doesn't use an Excel add-on and I found it. Thanks mate!

[hokageofgaming]

This helped greatly for my statistics class! Thank you so much!

[queenymariefrancisco]

Thank you for this video! I tried it on the mobile app and it works.💗

[Googs]

This was the best! Thank you so much, like most commenters here this was super helpful!

[destinycyh]

Thank you so much, its fast simple yet informative :)

[jcjohnson]

Thanks man, great video! Very helpful!

[rb]

if i knew this much i wouldn't search for it on youtube mate! i forgot why i came here after watching this video.

[Lamemon]

Thank you so much, this is very helpful for my Exam :)

[ranswift]

I just wanna ask how did you made or came up with the score range. A little bit lost, I would very much appreciate your reply. Thank youuu

[umairasrar]

you saved my life - currently working at 5 am

[manishankarjntu]

very use full... and thanks "f4" trick

[sarkisgaladjian]

Thanks SM! helped with my Stats Class!

[cprashanthkumarjoshi]

hi buddy, the video was great!
I have question, using countifs function you have derived the value for the range 31-40. Could you please tell us how to get the values automatically for remaining ranges without any a manual changes?