Channel: Simon Sez IT

Category: Science & Technology

Tags: excel tutorialcountif excelexcel sumififna function in exceliferrorexcel logical functionssumifs excelcountifsexcel ifsumif excelexcel orexcel tips and tricksexcel functionssumifaverageifsnested if in excelaverageiflogical functionssumifsiferror function in excelexcel iferror functionexcel formulas and functionsexcel ifnalogical functions in excelexcel if functionexcel formulascountifnested ififerror functionexcel countif

Description: In this Excel 2021 tutorial, we take a look at Logical Functions in Excel such as IF, IFS, COUNTIF, and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel knowledge. This was taken from a live, recorded webinar. You can download the Excel demo file used in this tutorial below and follow along. Download the exercise file and follow along here ►simonsezit.com/article/how-to-use-logical-functions-in-microsoft-excel Timestamps: 0:00:00 - What are Logical Functions? 0:01:04 - Simple Logical Tests 0:04:11 - Adding Meaning using IF Statements 0:08:57 - Using SUM and IF to Perform Logical Calculations 0:11:22 - Working with AND and OR 0:16:31 - Nested IF Statements 0:23:01 - The IFS Functions 0:27:48 - COUNTIF(S), SUMIF(S), and AVERAGEIF(S) 0:38:55 - Error Checking with IFNA and IFERROR Take a look at the latest Excel training courses from Simon Sez IT ►bit.ly/3fNO5mw For more recorded webinars from Simon Sez IT, take a look at this playlist ►youtube.com/playlist?list=PLzj7TwUeMQ3i4Byo1_NLrPDrxNp2NK66s Watch more popular MS Office tutorials from Simon Sez IT: Microsoft Excel 2019 Tutorial (3-Hour Course for Beginners) ►youtu.be/ZNGqeCcTu0Q Windows 10 Tutorial (3.5-Hour Guide plus Tips) ►youtu.be/z2r-p7xc7c4 Learn PivotTables in 1 Hour (Excel Crash Course) ►youtu.be/2RKw-HGCLB0 Introduction to QuickBooks Desktop 2021 (4-Hour Tutorial) ►youtu.be/-K357CmF0Xk The Ultimate Excel 2016 Crash Course (6-Hour Course for Beginners) ►youtu.be/sM0Lldwt7iA Other, free Microsoft Excel playlists from Simon Sez IT: Microsoft Excel 2019 Beginners playlist ►youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg Microsoft Excel 2019 Advanced playlist ►youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9 Stay in touch! SimonSezIT.com: SimonSezIT.com StreamSkill.com: StreamSkill.com YouTube Channel: youtube.com/user/simonsezittraining Subscribe to our channel: youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)