Learn how to use SUMIFS, COUNTIFS, AVERAGEIFS formulas. This tutorial shows how to SUM, AVERAGE or COUNT with condition, total range between dates, total when cell contains text, use multiple criteria, SUMIFS, COUNTIFS, AVERAGEIFS from another sheet (tab), use greater than or less than criteria and much more.