Sum with Multiple Criteria - Row and Column | Excel

When it comes to summing data with multiple criteria the first function that pops into mind is SUMIFS. However if matching on both row and column it will not work so in this video I discuss some alternatives. These will work with both standalone Excel and Microsoft 365.

*Excel Version*
* Recorded using Excel Pro Plus 2021
* MS 365 gets regular updates and in some cases, new functions, which could make this solution simpler or even different.

*Excel Tips Playlist*
https://www.youtube.com/playlist?list=PL8zztIrMXMC7H595kmYDJF_yFE0JNk2OW

Видео Sum with Multiple Criteria - Row and Column | Excel канала XLWizardry