Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: Download File: http://ift.tt/2zj989b
Download Excel Finished File: Download File: http://ift.tt/2zzfp18
Download Full Written Notes: http://ift.tt/2zlAQSq
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (00:41) Different kinds of counting and adding
3. (02:28) Function Drop-down and screen tips to learn which function to use
4. (04:05) COUNT Function
5. (05:04) COUNTA Function
6. (06:16) SUM Function
7. (06:55) COUNTIFS Function
8. (10:14) Screen Click Trick to highlight an entire argument in a function.
9. (11:04) Be Careful of Spaces!!!!!
10. (11:48) SUMIFS Functions
11. (15:05) Use Ctrl Key to check your answers
12. (15:53) More Examples
13. (19:14) Homework you can do to practice
14. (20:06) Summary – Conclusion

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.