Sum, count or average cells e.g. bigger than
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.