Sum, count or average with many conditions

Please purchase the course before starting the lesson.

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.

Back to: Advanced Excel Course > SUM, COUNT, AVERAGE IFS