Sum, count or average with many conditions
The reason we focus on the IFS options (rather than the simpler SUMIF) is that they allow you to specify many conditions e.g. if the person is in Department A and sales are bigger than 10 add it up.
Although we would normally advise you use a Pivot Table, the IF’s functions allow you to achieve the same thing within a formula.
Watch the video clip to see how this works.
To see the full course contents click here.