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?
This could have been dynamic without using macros... Like you can mention scores range in separate cells and give cell references instead of mentioning upper and lower levels in formula itself. And, There are 2 other methods apart from countifs. 1. you can use pivot table by grouping the range. 2. You can also use vlookup with true By the way... I am a big fan of yours... You are my excel guru.
Thank you SOOOO much! You're really awesome!💯 🎆This video was so very helpful that I can't begin to tell you how much it actually helped me. Plus, you're accent is so cool! Love it! Are you British?💚💚💗💓💖😌😌🤗👍💣😌
@@Computergaga Would you be so kind to do a video on this please? I found the process you used on this video much easier, but when I tried the "=FREQUENCY" command, I couldn't get the proper values. Your video helped me a lot, great work!
If you're on a Windows machine, F$ will work but you may need to press the Fn key at the same time, or before to turn it on. It depends on the keyboard.
Click and drag using the small square in the bottom right of the cell. Thd mouse cursor changes from a large white cross to a small black cross when its ready to drag.
@@Computergaga I wanted to ask a question. I am currently doing an excel hw, i have to find the number of male and female offenders their frequency. I am having trouble finding the frequency for both
what key did you press when you add "$" at 1.45? because you add 4 $ at one time, but I always type it one by one. can you tell me that? Is it f4? thanks
This method is tedious and works only for a limited no of data as you have to enter the range in the "countifs" function each time.Excel has an already in-built function for creating frequency distributions which is much easier
It certainly is now in the modern versions if you are referring to the FREQUENCY function Soudip. This video was shot in 2014 and FREQUENCY is an array function which was not nice back then.
Ouch! These are just typed in and formatted my friend. Nothing special going on there. Just some made up frequencies for demonstration and manually typed.
9 Years later, and still best and simplest video out on youtube to get class intervals done quickly. Thanks Mate!!
You're welcome! Thank you.
Excellent video. 7 years later you made my day a whole lot easier :)
Great to hear. Thank you.
Thank you, my friend! This video helped me in my Statistics Math Course.
Great!
Still the best vid 10 yrs later. I'm using excel for the rest of my statistics class.
Great! Thank you.
Pretty easy steps. Helped me a lot when I was about to give on the test😄
Thank you for making my life easy🙂
My pleasure 😊
10 years late, and it still works! thank you
Great to hear! My pleasure.
I love you you saved my life literally the amount of time I spent trying to count the data set
No worries. Good to hear.
❤❤😅😅 thanks 9 years later still works !!!
You made my day 9 years later🎉
Great! That is awesome!
you saved my life - currently working at 5 am
Awesome! Happy to help, Umair.
Looking for a video that doesn't use an Excel add-on and I found it. Thanks mate!
You're welcome.
Thanks for clearing this up ❤️
thank you, saved me 3hours!!!!!!!!!!!!!
Great to hear. My pleasure.
Thank you for this video! I tried it on the mobile app and it works.💗
Excellent!
Thank you so much, this is very helpful for my Exam :)
Glad it helped!
Sir you saved my day..! I slept in my class. I did my home work now. .. 🙄
Great 👍
if i knew this much i wouldn't search for it on youtube mate! i forgot why i came here after watching this video.
Thanks SM! helped with my Stats Class!
Glad it helped!
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?
instablaster...
This could have been dynamic without using macros... Like you can mention scores range in separate cells and give cell references instead of mentioning upper and lower levels in formula itself.
And, There are 2 other methods apart from countifs.
1. you can use pivot table by grouping the range.
2. You can also use vlookup with true
By the way... I am a big fan of yours...
You are my excel guru.
Thank you Abhi.
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
Thank You My Friend. Helped a Lot.
Great to hear. Thank you.
This helped greatly for my statistics class! Thank you so much!
You're very welcome.
Well explained and excellent 🎉Thank you very much
You are welcome! Thank you very much for your comments.
Thank you for making this video
No problem 😊
Thank you SOOOO much! You're really awesome!💯 🎆This video was so very helpful that I can't begin to tell you how much it actually helped me. Plus, you're accent is so cool! Love it! Are you British?💚💚💗💓💖😌😌🤗👍💣😌
You're very welcome. Yes, I am 😊
thanks it was very easy tutorial
Hi, I found your video useful. But we were taught a little different, this way, the second argument in COUNTIFS should be
Thanks Dexter.
Yes both are appropriate depending on the situation and the value. In this video I used
Thanks a lot for the info, very easy way of constructing a table.
super sir you make more videos thank you
I will endeavour. Thank you 😊
this is a great video. i wonder why the thumbs down are so high? strange.
Thank you, David 👍
Amazing bro
very helpfull video
Thanks ✌️
saved my ca1 ty
My pleasure!
This was the best! Thank you so much, like most commenters here this was super helpful!
That is great to hear. Thank you.
Thank you so much, its fast simple yet informative :)
Excellent! Thank you.
Sir, can we find frequency while using =frequency()? Because it was showing in help book of excel.
Yes, absolutely. The FREQUENCY function is improved in Excel 365, now that is can handle arrays.
@@Computergaga Would you be so kind to do a video on this please? I found the process you used on this video much easier, but when I tried the "=FREQUENCY" command, I couldn't get the proper values. Your video helped me a lot, great work!
THANK YOU SO MUCH, YOU HELP ME A LOT !
Great to hear. My pleasure Thái Sơn.
Thanks man, great video! Very helpful!
You're welcome. Thank you.
very use full... and thanks "f4" trick
You're welcome Manishankar.
What can we do if f4 doesn’t work on our computer? Thanks
If you're on a Windows machine, F$ will work but you may need to press the Fn key at the same time, or before to turn it on. It depends on the keyboard.
So useful thankyou!
You're very welcome.
How are you copying and pasting the equation to the other cells? I can't figure it out and have just copied and pasted each individually.
Click and drag using the small square in the bottom right of the cell. Thd mouse cursor changes from a large white cross to a small black cross when its ready to drag.
is there any way to not have to retype the range for every box
Very helpful, thank you!
You're welcome Lorna.
i am indebted towards you sir
My pleasure Hafiz.
great vid awesome name love gaga and you are a great man
Thank you kindly
What should we press to fix
Can you just count them also? individuality?
Sure.
@@Computergaga I wanted to ask a question. I am currently doing an excel hw, i have to find the number of male and female offenders their frequency. I am having trouble finding the frequency for both
what key did you press when you add "$" at 1.45? because you add 4 $ at one time, but I always type it one by one. can you tell me that? Is it f4? thanks
Yes sure was. F4 key.
Hi there, it didn’t work for me. It added them up incorrectly, only gave me a total of 88, should have been 100.
How about construct a frequency dist by using table with eight classes with equal intervals?
how to find if list contains absent student while using =countifs() . pls provide modification in formula to avoid value error
How can write the formula dynamically?
1:34 how did you select all data I'm trying to use Ctrl+A but it select all the sheet?
I did the Ctrl + Shift + down arrow combination from cell C4.
@@Computergaga It works!!!
Thanks ALOT
really helpful, thanks a lot!
Excellent! You're welcome, Amir.
I am unable to use the F4 function as I have windows 10 and as soon as i press f4, option to open projector opens. What is the alternative of f4?
It will still be the F4 key, but it sounds like you need to press the Fn key at the same time. The F4 key has dual purpose.
@@Computergaga Yes, I tried and it worked! Hope you'll solve my more doubts in excel! Thank You so much!
You're very welcome Vishesh 👍
Is this a grouped data???
Thank you
You're welcome, Anish. Thank you.
How did you create the score range?
It was just typed out.
Can we not hardcode the range values and put cell reference instead ?
Sure. You would need to hardcode logical operators such as ">="&B4. Unless you write those symbols in the cell also.
Thankkk you!
You're very welcome.
Hello, got a problem F4 in Hp doesn't work. Pls help.
You probably need to press and hold the function key "Fn" on the keyboard as you press F4.
Thanks it really works! 🤩 But my nxt problem is that the formula doesn't work for it did not runs out. What to do?
thank you, it's really helpful)
Great! You're welcome Elly.
Bad programming. If I change values in E4 to E12 what will be result?
Why cant we add cell reference instead of values?
THANKS BROTHER
Happy to help Phateh.
how to make this template
why is it giving me answers in percentage .
i performed at two different projects one was fine
one has percentage issues
Sounds like formatting. You can change the number format to General or whatever is needed.
Wonderful
Thank you, George.
Thanks, helped alot :D
Brilliant! Thank you.
thank you. my teacher expects everyone to know how to use excel good grief
You're welcome Gideon.
Excellent video or else I would have manually counted the data... Thanks
You're welcome, Arsalan. Thank you.
F4 goona fix that range
Put speed on 1.5 saves a lot of time
cheers m8 saved my ass
Happy to help 👍
nice
Thank you 👍
Tq sir
You're welcome, Parasu.
This method is tedious and works only for a limited no of data as you have to enter the range in the "countifs" function each time.Excel has an already in-built function for creating frequency distributions which is much easier
It certainly is now in the modern versions if you are referring to the FREQUENCY function Soudip.
This video was shot in 2014 and FREQUENCY is an array function which was not nice back then.
@@Computergaga Yeah was referring to the "histogram" function now available as an add-in...dont know if it was there back then
Ah cool buddy. Think that came out in 2016. Forgot about that one.
really difficult method for a beginner like me. :(
Sorry. This video is very old, though still applies. The FREQUENCY function is improved in modern Excel, but it does depends how you set up your data.
how to press F4
Depends on your keyboard, but you may need to press the function key, probably labelled 'Fn' on the keyboard as you press F4.
Who else here trying to get lotto numbers? 🤣
when i pressed f4 my sound wa muted
You may need to press or press and hold the Fn key as you press F4.
TUCHORIAL
😯
@@Computergaga sowy
Lost me at press f4…..
😊
I dont understand your english sound bad
disliked because you didnt tell me how to make the table that the frequencies are found in, good effort though!
Ouch! These are just typed in and formatted my friend. Nothing special going on there. Just some made up frequencies for demonstration and manually typed.
Great video. Thank you!!
Thank you, Sharmila.
Thank you
No problem.