Sumifs

7 lessons in order

Learn how to use SUMIFS with multiple criteria in the same column in Excel by combining conditions, using SUMPRODUCT & optimizing formulas.

Learn how to use the SUMIFS function in Excel with multiple sheets by combining it with SUMPRODUCT, INDIRECT, and the plus (+) operator.

Learn how to use SUMIFS in Excel with a date range and multiple criteria using TODAY, DATE functions, and dynamic filters.

Learn how to use SUMIFS in Excel with multiple criteria across columns and rows, including date ranges, wildcards, and numeric conditions.

Learn how to use SUMIF in Excel with a date range by month using SUMIFS, EDATE, and EOMONTH functions for dynamic & accurate monthly totals.

Learn how to use the SUMIFS function in Excel with “not equal to” text criteria for exact, partial, and multiple condition matching.

Learn how to sum ranges across multiple columns in Excel using SUMIFS, BYCOL, INDEX, OFFSET, VBA, and other powerful methods.