SUMIF, COUNTIF, SUMIFS and More: The Complete Guide to Conditional Totals in Excel

Twelve functions, one continuous lesson: every common way to total or count rows in Excel based on a condition, from a single SUMIF to a full SUMIFS wildcard and date range pattern, plus a common COUNTIF mistake and how to fix it. Chapters: 0:00 SUMIF 0:36 COUNTIF 1:03 SUMIFS 1:33 COUNTIFS 2:04 AVERAGEIFS 2:42 MAXIFS 3:10 MINIFS 3:38 SUMIFS with a wildcard 4:04 COUNTIFS with a wildcard 4:30 SUMIFS across a date range 4:58 COUNTIFS across a date range 5:26 COUNTIF returning zero (a common mistake) Part of GridGo's Excel formula series.