Logical Functions In Excel Tutorial (IF, IFS, AND, OR, COUNTIF, SUMIF): Excel Formulas and Functions

Simon Sez IT January 22, 2020
Video Thumbnail

About

No channel description available.

Video Description

✅ Download the exercise files and follow along here: ➡️https://www.simonsezit.com/article/logical-functions-in-excel/ In this Excel tutorial, we take a look at Logical Functions in Excel. That's functions such as IF, IFS, COUNTIF and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel. This was taken from a live, recorded session. You can download the Excel files that Debs uses below and follow along. Download the exercise files and follow along here ► https://www.simonsezit.com/article/logical-functions-in-excel/ In this session we covered: - The IF Function - Nested IF in Excel - The IFS Function - The AND and OR Functions - COUNTIF and SUMIF - Error checking Functions IFERROR and IFNA 🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/ 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU ✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg ✅ Pivot Table Tutorials for Beginners here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i80FzwXA86zJOK8dtlB-qt ✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc ✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ FaceBook: https://www.facebook.com/SimonSezIT 🔔 Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Upgrade Your Tech Today

AI-recommended products based on this video

Loading...
Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

(2,272)
$43.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
45W Super Fast Charger USBC Charger, 2Pack 10FT Samsung Charger Fast Charging Cord Cable& Samsung Type C Charger Block for Galaxy S25 S24 S23 S22 S21 Ultra/Plus, Tab S10 S9 S8 S7,iPad,Android Phone

45W Super Fast Charger USBC Charger, 2Pack 10FT Samsung Charger Fast Charging Cord Cable& Samsung Type C Charger Block for Galaxy S25 S24 S23 S22 S21 Ultra/Plus, Tab S10 S9 S8 S7,iPad,Android Phone

(52)
$22.79
FREE delivery Fri, Oct 3 on your first order
1K+ bought in past month
Loading...
Samsung Galaxy Tab S10 Ultra Gray 256GB - AI Tablet, 14.6", AMOLED 2X, Anti-Reflection, 420 Nits, Vapor Chamber, S Pen Included (CAD Version & Warranty)

Samsung Galaxy Tab S10 Ultra Gray 256GB - AI Tablet, 14.6", AMOLED 2X, Anti-Reflection, 420 Nits, Vapor Chamber, S Pen Included (CAD Version & Warranty)

(77)
$1,099.99$869.90
FREE delivery Wed, Aug 27
50+ bought in past month
Loading...
Wireless Charger for Samsung Charging Station with Clock for Samsung Galaxy S25 Ultra/S24 Ultra/Z Flip 6/Fold 5/Bud, 3 in 1 Charger Station Watch Charger for Samsung Galaxy Watch 7/6/5Pro(Wood Grain)

Wireless Charger for Samsung Charging Station with Clock for Samsung Galaxy S25 Ultra/S24 Ultra/Z Flip 6/Fold 5/Bud, 3 in 1 Charger Station Watch Charger for Samsung Galaxy Watch 7/6/5Pro(Wood Grain)

(1,430)
$49.99$39.96
PrimeFREE delivery Sun, Jun 15
Loading...
Wireless Charger for Samsung Charging Station, 3 in 1 Android Phone Wireless Charger for Samsung Galaxy S25 Ultra/S24 Ultra/S23/Z Flip 6/Fold 6/Buds, Charger for Galaxy Watch Ultra/7/6/5/4/3 (Black)

Wireless Charger for Samsung Charging Station, 3 in 1 Android Phone Wireless Charger for Samsung Galaxy S25 Ultra/S24 Ultra/S23/Z Flip 6/Fold 6/Buds, Charger for Galaxy Watch Ultra/7/6/5/4/3 (Black)

(7,328)
$42.99
PrimeFREE delivery Sat, Jun 14
50+ bought in past month
Loading...
Wireless Charger for Samsung Devices, Wireless Charging Station for Galaxy S25 Ultra/S25+/S25/S24 Ultra/Z Fold/Z Flip/S23/S22/S21, for Galaxy Watch7/Ultra/6/6 Classic/5 Pro/5/4, Galaxy Buds3 Pro

Wireless Charger for Samsung Devices, Wireless Charging Station for Galaxy S25 Ultra/S25+/S25/S24 Ultra/Z Fold/Z Flip/S23/S22/S21, for Galaxy Watch7/Ultra/6/6 Classic/5 Pro/5/4, Galaxy Buds3 Pro

(3,510)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

(2,272)
$43.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
Wireless Charger for Samsung Devices, Wireless Charging Station for Galaxy S25 Ultra/S25+/S25/S24 Ultra/Z Fold/Z Flip/S23/S22/S21, for Galaxy Watch7/Ultra/6/6 Classic/5 Pro/5/4, Galaxy Buds3 Pro

Wireless Charger for Samsung Devices, Wireless Charging Station for Galaxy S25 Ultra/S25+/S25/S24 Ultra/Z Fold/Z Flip/S23/S22/S21, for Galaxy Watch7/Ultra/6/6 Classic/5 Pro/5/4, Galaxy Buds3 Pro

(3,510)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

(2,272)
$43.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
Spigen Case for Galaxy S25 Case, Tough Armor (Ai) MagFit [Wireless Charging] Compatible with MagSafe - Black

Spigen Case for Galaxy S25 Case, Tough Armor (Ai) MagFit [Wireless Charging] Compatible with MagSafe - Black

(2,126)
$28.99
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Spigen Case for iPhone 16 Case, Tough Armor Designed for Apple iPhone 16 - Black

Spigen Case for iPhone 16 Case, Tough Armor Designed for Apple iPhone 16 - Black

(126)
$22.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
Spigen Case for iPhone 16 Pro Case, Tough Armor [MagFit] Compatible with MagSafe - Black

Spigen Case for iPhone 16 Pro Case, Tough Armor [MagFit] Compatible with MagSafe - Black

(341)
$32.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Spigen Case for iPhone 16 Plus Case, Tough Armor (AI) [MagFit] Compatible with MagSafe - Black

Spigen Case for iPhone 16 Plus Case, Tough Armor (AI) [MagFit] Compatible with MagSafe - Black

(818)
$29.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Galaxy S24 S25 USB C Charging Block 25W PD Super Fast Charger Type C Wall Plug Adapter Quick Charge for Samsung Galaxy S25/S24/S23/S22/S21/S20/Z Fold 3/4/5/Note20/iPhone 15/16/iPad/Tablet/Watch-1Pack

Galaxy S24 S25 USB C Charging Block 25W PD Super Fast Charger Type C Wall Plug Adapter Quick Charge for Samsung Galaxy S25/S24/S23/S22/S21/S20/Z Fold 3/4/5/Note20/iPhone 15/16/iPad/Tablet/Watch-1Pack

(7,777)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
SanDisk 128GB 2-Pack microSDXC Card, Licensed for Nintendo Switch (2x128GB) - SDSQXAO-128G-GN6Z2

SanDisk 128GB 2-Pack microSDXC Card, Licensed for Nintendo Switch (2x128GB) - SDSQXAO-128G-GN6Z2

(322,464)
$48.90
PrimeFREE delivery Sat, Jun 14
Loading...
SanDisk 256GB Ultra microSDXC UHS-I Memory Card with Adapter - Up to 150MB/s, C10, U1, Full HD, A1, MicroSD Card - SDSQUAC-256G-GN6MA

SanDisk 256GB Ultra microSDXC UHS-I Memory Card with Adapter - Up to 150MB/s, C10, U1, Full HD, A1, MicroSD Card - SDSQUAC-256G-GN6MA

(217,850)
$24.63$19.70
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

(71,074)
$21.99$16.59
FREE delivery Sun, Aug 10 on your first order
500+ bought in past month
Loading...
SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN
Best Seller

SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN

(71,074)
$29.99$26.61
FREE delivery Sun, Aug 10 on your first order
4K+ bought in past month
Loading...
JoyGeek 3-in-1 Magnetic Wireless Charging Station for iPhone 16/15/14/13/12 Series & Apple Watch Ultra 2/SE; 360° Adjustable Phone Stand with 18W Adapter, Compatible with AirPods Pro/3/2 Recycled Claim Standard Blended

JoyGeek 3-in-1 Magnetic Wireless Charging Station for iPhone 16/15/14/13/12 Series & Apple Watch Ultra 2/SE; 360° Adjustable Phone Stand with 18W Adapter, Compatible with AirPods Pro/3/2 Recycled Claim Standard Blended

(959)
$19.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

(2,272)
$43.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month