How to Use the SUMIF Function in Excel in 4 Steps [+Examples]

Learn how to use the SUMIF function to SUM cells that meet a certain criterion🧮 I walk you through how to write the criterion, which can be a bit tricky, along with the most common use cases for the function: less than, equal to, and less than or equal to💪

🕒 TIMESTAMPS
0:00 What is the SUMIF function?
1:14 Step 1: Write the function name =SUMIFS(
1:30 Step 2: (Criteria) range
1:53 Step 3: Criteria argument
2:30 Step 4: Sum_range argument
3:30 Greater than, less than, and less than or equal to

👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!

🍿 RECOMMENDED VIDEOS
SUM cells with multiple criteria (SUMIFS): The Excel SUMIFS Function

🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: https://spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: https://spreadsheeto.com/free-power-b...

🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: https://spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: https://spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: https://spreadsheeto.com/power-bi/

🧑‍💻HIRE ME AND MY TEAM
We develop custom Excel systems: https://spreadsheeto.com/excel-consul...

#exceltips #exceltutorial #microsoft365 #officeproductivity

• #education
• #excel_sumif
• #sum_with_criteria_excel
• #excel_sum_specific_cells
• #sumif_tutorial
• #microsoft_office
• #microsoft_365
• #how_to_use_sumif_function
• #excel_sumif_guide
• #excel_sumif_step_by_step