Sum, count or average cells e.g. bigger than

Please purchase the course before starting the lesson.

The SUMIFS, COUNTIFS, AVERAGEIFS and other similar functions can also be used to compare IF numbers meet a condition e.g. count all the cells where profit is bigger than zero.

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