Excel Functions & Formulas

69 articles

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 with multiple criteria in the same column in Excel by combining conditions, using SUMPRODUCT & optimizing formulas.

Learn how to use SUMIF with multiple criteria for different columns in Excel using SUMIFS, combined conditions, matrix layout & SUMPRODUCT.

Learn how to use SUMIF across multiple sheets in Excel by combining SUM, SUMPRODUCT, and INDIRECT functions to sum data efficiently.

Learn how to sum in Excel if a cell contains text from another cell using SUMIF, SUMIFS with wildcards, and the SUMPRODUCT function.

Learn how to check if a cell contains text from a list in Excel using SEARCH, COUNTIF, XLOOKUP, INDEX, and more powerful functions.

Learn how to use the INDIRECT function in Excel to reference cells, ranges, and sheets dynamically for advanced cross-sheet data handling.

Learn how to return the cell address of a match in Excel using ADDRESS, MATCH, INDEX, XLOOKUP, CELL functions, and named ranges.

Master using VLOOKUP with two lookup values in Excel by applying helper columns, the CHOOSE function, or nested formulas for precise results.