Aggregation & Counting

Use SUMIFS to add numbers only when rows match two or more conditions.

Use SUMIFS to total values for a specific month from a table with transaction dates.

Count rows between two dates in Excel or Google Sheets with COUNTIFS.

Fix SUMIFS formulas that return zero, wrong totals, or errors because of mismatched ranges or criteria issues.

Understand the practical ways to total colored cells in a spreadsheet.

Count cells by color using a safer helper-column approach instead of relying on formatting as data.

Count distinct names, IDs, emails, or categories in a spreadsheet range.

Use AVERAGEIFS to calculate a monthly average from dated rows.

Use COUNTIFS to count rows that match multiple conditions.

Use AVERAGEIFS to calculate an average only for rows that match your criteria.

Create a cumulative total that adds each row to the total above it.

Calculate percentage increase or decrease between an old value and a new value.