Excel Forum



You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS


See how to add with multiple criteria using a Pivot Table (PivotTable), the SUMPRODUCT function and the SUMIFS function! Also see how to create many formulas all at once by using the correct type of cell references.

Pivot Table (PivotTable) for summing with multiple criteria
SUMPRODUCTS function for summing with multiple criteria (Array Formula)
SUMIFS function for summing with multiple criteria





Got a Question? Ask it Here in the Forum.