Some formulas are more complex than others. For example, compound functions combine two or more functions, such as SUMIF, which integrates SUM and IF functions but operates differently from what one might expect.

<div style="display: flex; justify-content: center;">
<i>=</i><b>SUMIF</b>(<span style="color: indigo">range</span>, &nbsp;<span style="color: green">criterion</span>,&nbsp;<span style="color: brown">[sum_range])</span></div>

|    |                                                                                               |
|-------------|-----------------------------------------------------------------------------------------------|
| <span style="color: indigo">range</span> | The range of cells that you want to apply the criteria to.                                   |
| <span style="color: green">criterion</span>  | The condition or criteria to be met. For example, `">5"` to sum values greater than 5.      |
| <span style="color: brown">[sum_range]</span> | <i>(Optional)</i> The actual cells to sum if they meet the criteria. If omitted, the function sums the cells specified in the `range`.  |

It's important to understand that the criterion applies to the values or cells being evaluated for summation, not the sum itself. It’s easy to get confused and think that if the criterion isn't met, the function won’t return a sum.

You can break up this functions into a components and find the steps it do to emulate how it works. Let's start with and IF formula.

After that you can simple use SUM formula for the `C1:C6` cells and get the same result as in the SUMIF formula. But SUMIF formula is more convininent as it does all of this in one step and less error prone as you don't need to add a condition for `if_false` in IF formula.

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.

In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.

In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.


range	The range of cells that you want to apply the criteria to.
criterion	The condition or criteria to be met. For example, `">5"` to sum values greater than 5.
[sum_range]	(Optional) The actual cells to sum if they meet the criteria. If omitted, the function sums the cells specified in the `range`.

Excel Formulas

SUMIF