The Excel COUNTIF and COUNTIFS Functions
Technology for Teachers and Students
@techteachersandstudentsAbout
I'm an educator and educational technology enthusiast. The videos on this channel will help you learn how to use a wide range of computer software applications, educational websites, and other technology tools. Watch for a new video every Monday! Connect with me on the services you see below in the Links section.
Video Description
Learn to use the powerful COUNTIF and COUNTIFS functions. You can use these functions to tell Excel under what circumstances to count a range of data. Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelcountifs #excel #exceltutorials #microsoft365 #microsoftexcel Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join
Upgrade Your Tech
AI-recommended products based on this video

BASESAILOR iPhone 16 16e Car Charger Adapter 3Pack,USB to USBC Connector Type C Female to A Male Cable Converter for iPhone 15 14 Pro Max Plus,Apple Watch 10,Airpods 4,iPad mini 7,Samsung Galaxy S25

URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro
![VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung](https://m.media-amazon.com/images/I/71bHSP1cRkL._AC_UL960_FMwebp_QL65_.jpg)
VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods

4-in-1 Wireless Magnetic Power Bank 10800mAh Portable Charger with iWatch Charger, QC4.0+20W PD Fast Charging USB C Battery Pack for Magsafe, iPhone 16/15/14/13/12 Series, Apple Watch etc. (White)

eazpower for Magsafe Power Bank 10000mAh, Magnetic Battery Pack Wireless, 20W PD Fast Charging, Compact Portable Charger with Built-in Cables and Stand for iPhone 16/15/14/13/12/ Apple Watch/Airpods

Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

Telaso for iPhone 16 Pro Max Case, iPhone 16 Pro Max Phone Case Compatible with Magsafe Translucent Matte Back Slim Fit Full Body Shockproof Cover for iPhone 16 Pro Max 6.9", Black

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

Telaso for iPhone 16 Pro Case, iPhone 16 Pro Phone Case Compatible with Magsafe Translucent Matte Back Slim Fit Full Body Shockproof Anti-Yellow Cover for iPhone 16 Pro 6.3",Yellow

OHLPRO Tablet Holder for Car, iPad Holder for Car Air Vent Mount, Universal Dashboard Windshield 2-in-1 Cradle TPU Suction Sticky Gel for iPad/iPad mini Samsung Galaxy Size 6"- 10.5" iPad Car Holder

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 17 Pro Max Vent Clip Hand Free Cell Phone Car Mount for iPhone Air 17 16 Pro Max Samsung S25 Car Accesorries
![Miracase Car Phone Mount, [2025 Upgraded Strong Military Grade Suction Cup] Long Arm Phone Holder for Car Dashboard Windshield Vent, Hands Free Cell Phone Holder Compatible with All Mobile Phones Global Recycled Standard](https://m.media-amazon.com/images/I/81oehGW5OLL._AC_UL960_FMwebp_QL65_.jpg)
Miracase Car Phone Mount, [2025 Upgraded Strong Military Grade Suction Cup] Long Arm Phone Holder for Car Dashboard Windshield Vent, Hands Free Cell Phone Holder Compatible with All Mobile Phones Global Recycled Standard

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White
![iPhone 16 15 Charger [Apple MFi Certified] 2 Pack USB C Wall Charger Block 6FT USB C to Type C Cable Compatible with iPhone 16 15 Pro Max,16e, AirPods Pr, iPad Pro12.9/11, Samsung/Android Phones](https://m.media-amazon.com/images/I/51GjkZn3ACL._AC_UL960_FMwebp_QL65_.jpg)
iPhone 16 15 Charger [Apple MFi Certified] 2 Pack USB C Wall Charger Block 6FT USB C to Type C Cable Compatible with iPhone 16 15 Pro Max,16e, AirPods Pr, iPad Pro12.9/11, Samsung/Android Phones

Spigen Case for iPhone 15, iPhone 14, and iPhone 13, Ultra Hybrid MagFit Designed for Apple iPhone 15/14/13 - Crystal Clear

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

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

USB C Headphones for iPhone 17/16/16e/15 Pro Max/Plus, Type C Earbuds Wired Earphones (Microphone & Remote Control) Noise Cancelling for lPad Pro, Galaxy S23/S22/S21/S20

USB C Headphones for iPhone 17/16/16e/15 Pro Max/Plus, Type C Earbuds Wired Earphones (Microphone & Remote Control) Noise Cancelling for lPad Pro, Galaxy S23/S22/S21/S20/Ultra Note10/20, Pixel

Google Pixel Buds Pro 2 - Noise Canceling Earbuds - Up to 31 Hour Battery Life with Charging Case - Bluetooth Headphones - Compatible with Android - Hazel




















