Excel SUM / SUMIF / SUMIFS explained.

Learn about the various SUM functions and how to use them in different scenarios using constants, cell references, strings and wild cards. This is a complete tutorial so even if you are totally new to Excel you will learn how to use the various functions.
This is a great tutorial for anyone taking the Cambridge ICT IGCSE 0417 Examination [ IGCSE ICT 0417 ].

0:00 Intro
0:59 An analogy of the functions SUM, SUMIF, SUMIFS to understand them before implementing them
3:54 Understanding the worksheet we will be working with
5:37 understanding the purpose of the = sign

---------------------------
SUM function
---------------------------
6:38 Basic SUM
7:46 SUM with ranges (selecting multiple ranges)
9:43 Sum with extra criteria, including constants or cell reference
10:53 Nested functions

--------------------------
SUMIF function
--------------------------
12:47 Understanding the SUMIF function
14:16 SUMIF using text criteria and cell references
19:13 SUMIF with a string search using text and cell references
(understand the advantage of using cell references)
21:57 understanding wildcards
24:32 SUMIF using strings and wildcards (understanding wildcards)
26:08 How to OR SUMIF functions (ORing). Nesting SUMIF functions
28:21 SUMIF function with ORing

--------------------------
SUMIFS function
--------------------------
30:40 Understanding the SIMIFS function and the parameters required
34:03 SUMIFS example with cell reference
38:06 SUMIFS example with strings and wildcards. Use of concatenating to use cell reference for the wildcard criteria.

Download the Excel file used in this tutorial:

[avnishtonape]

Thank You so much I got full marks in my mock exams thanks to your tutorials

[TamillegendaryGamer]

thank you sir this was a really useful video for my studies in ict

[vihaanviswanath]

Hey Nicos! I got an A(88) in ICT IGCSE this feb/march 2024 all thanks to your videos 😄😄 Without your help I couldn't have accomplished it. Btw wondering do you teach for IT As and A level?
Wondering if you could make some videos on it :)

[ccsc-sohammaity]

hi sir, can you please make a quick brief video on filter, custom sortings, using those wildcards for filter using exclamation etc. I have my paper 3 mock exam this friday, please help

[omerelfaroughabiballah]

hey man thanks for the really helpfull playlist, i hope you live a sweat beautiful life, really appreciate what your doing for the ict students

[KING-uhry]

Sir for the Sum range function of (F3:F15, excel is showing an error that "Formula omits adjacent cells" even you have that error see the green strap on the cell, but when I tried clicking on the symbol, there was an option "update formula to include cells" and when I clicked the option, it didn't make any change to the formula but gave an answer "416160" can you please help which one should I follow?

[bhuvanashreesai]

hey nicos thanks for giving a brief and detailed explanation
thanking for ages for my good score in particles
i would highly appreciate the tip that need to taken to crack my ict theory

[saranthilaka]

Sir can we use Microsoft front page for website authorising

[abbas_]

Hi sir is this full excel in your Playlist??