How to use SUM, SUMIF and SUMIFS Functions in Excel
In this video, we are going to learn about on how to use SUM,SUMIF and SUMIFS function in Excel. This is easy and quick tutorial whether you are a beginner in excel or brushing up your spreadsheet skills, this video breaks down the difference between SUM, SUMIF, and SUMIFS, showing you how to add values based on one or multiple conditions.
Learn how to:
Use the SUM function to total values quickly
Apply SUMIF to sum based on a single criterion
Master SUMIFS for multiple criteria in Excel
Timestamps
00:00 Introduction
00:10 What is SUM,SUMIF and SUMIFS
01:15 SUM
02:26 SUMIF
04:08 SUMIF with Cell Reference
05:46 SUMIFS with two Criteria
07:35 SUMIFS with three Criteria
09:34 Wrap up
Watch next: Other Related Tutorial Videos
Ms Word for Beginners: Master the Basics in No Time! - • Ms Word for Beginners: Learn Every Feature...
PowerPoint Made Easy for Beginners - • PowerPoint Made Easy for Beginners
Microsoft Excel Tutorial for Beginners 2025 - • Microsoft Excel Tutorial for Beginners 2026
Excel COUNTIF and COUNTIFS Tutorial That Will Make You an Expert
Don't forget to like, subscribe, and hit the bell for more Excel tips and formulas!