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/3ll4l37tflco9f259ebbv/AHDrHlS5Ad5SME-vMi6bKAk?rlkey=guttevj3han4773ley1hmmhyc&st=xbvvpz5s&dl=0