Excel Magic Trick
ฝัง
- เผยแพร่เมื่อ 6 ก.ย. 2024
- Download Excel Start File: people.highlin...
Download Excel Finished File: people.highlin...
Full Page With All File Links: people.highline...
Excelisfun is conducting a FAVORITE FORMULA SURVEY! Watch the 3 different Formulas in this video and then vote in the comment section for the one you like best! See SUMPRODUCT function formula, COUNTIF function formula and a SUM & IF function formula: vote for the one you like best!! All three formulas will count quantitative data in categories that include the lower limit but not the upper limit.
For more about Counting between an upper and lower value, see this video (In this video we include lower limit and upper limit): Excel Magic Trick #175: Count Between Upper & Lower Value
To learn about the FREQUENCY function, see this video (In this video we include upper limit but not lower limit): Excel Array Formula Series #8: FREQUENCY function
Dear JohnLarko,
Thanks for the input! SUMPRODUCT certainly is the most popular!
--excelisfun
Dear PrincessWithSkills,
Thanks for the feed back! BTW, SUM and IF is best for functions where zeroes would make a calculation incorrect (like Mean and Standard Deviation).
--excelisfun
Thanks for the input! There is still one more option that is fastest calculationg: COUNTIFS function.
I like SUMPRODUCT. In class I teach the COUNTIF and COUNTIFS methods.
Mines is SUMPRODUCT by a country mile!!! And thanks for sharing all your knowledge with us and for the time you take to make each lesson so detailed for clear understanding..very much appeciated!!!!!!!!!!!!!!!!!!!!!!!!!
Definitely SUMPRODUCT is in my opinion the most suitable one. Very easy to write it and I suppose that much faster than the second option. However the second one is worth to know. Above all the clip is awesome, since is giving us (you tubers) the possibility to choose.
Dear muss212,
Thanks for the input!
--excelisfun
Dear cidfidoutube,
Thanks for the input!
--excelisfun
My head understands the logic of Countif slightly better, so have to differ from the other responders and say i prefer that.
Keep up this wonderful series, I've learnt so much from them
thanks
Dear ziggle314,
Thanks for the input!
--excelisfun
Sumproduct is my choice. Great videos. Keep them up.
I did not use the * for a specific reason. Double Negative with commas would be faster calculating.
Search for this video title to see SUMPRODUCT with double negative, COUNTIFS, COUNTIF, FREQUENCY and Pivot Table to build a frequency distribution:
Mr Excel & excelisfun Trick 15: Frequency Distribution
Dear ziggle314 and JPB6969 and JohnLarko,
So far a clean sweep! I hope more people voice their opinion. I will take into account any pattern that emerges from the voting.
As for the videos, I'll keep making them, if you all keep watching them (rating too)!!!
--excelisfun
Dear JPB6969,
Thanks for the input!
--excelisfun
I prefer the sumproduct, thank you for all the videos
Dear scottylad2,
I usually teach the COUNTIF method in my Stats classes, however, I prefer the SUMPRODUCTS method. The reason that the SUMPRODUCTS method is usually harder for beginners is because of the TRUE FALSE Boolean math stuff.
If you want to learn more about Excel and Boolean Math, see this video:
Excel Magic Trick #63: Boolean Logic & Array Formulas
Excel Magic Trick #54: Logical Formulas & Boolean Math
Excel Array Formula Series #7: Boolean Logic & Criteria
--excelisfun
I was wondering why did u use * instead of coma between the arrays in the SUMPRODUCT, since the arrays have the same size. Did you make a video with countifs an the same topic?
I like Countif Formula sir
I would prefer "sumproduct"
sum & if, no complexity,str8 4ward