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:
https://www.dropbox.com/scl/fo/3ll4l3...