Essentials · Formulas

Conditional Aggregation

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. SUMIF and SUMIFSAll-Access Pass

   Build conditional totals with one or several criteria, keep the sum range distinct from the criteria ranges, and control date and comparison criteria through input cells.

   14 marked steps

2. 2. COUNTIF and COUNTIFSAll-Access Pass

   Count rows meeting one or several conditions, distinguish AND from OR, and reconcile subsets back to a controlled population.

   14 marked steps

3. 3. AVERAGEIF and AVERAGEIFSAll-Access Pass

   Average only the rows belonging to a defined population, diagnose an empty population, and distinguish an average order value from totals, counts and weighted measures.

   14 marked steps

4. 4. SUMIFS as a controlled lookupAll-Access Pass

   Use SUMIFS to retrieve a numeric value by key, prove that the key is unique, and distinguish a valid zero from a missing or duplicate record.

   14 marked steps

Finished Formulas? Sit the Formulas exam for its certificate.