Excel Forum
Similar Content
Easy Pivot Table in Excel (Auto-Subtotals Feature)
Tutorial: How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly ...
Text to Number Format Formula in Excel
Tutorial: Simple way to convert a number stored as text to a number stored as an actual number in E...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.