SUMIFS Function in Excel - Tutorial

The SUMIFS function in Excel will help you sum by criteria. It's like the SUMIF function, but you can sum multiple criteria with SUMIFS. You can include up to 127 different criteria in your SUMIFS formula. In this tutorial, we go over how to use the SUMIFS function: - With one criteria - To sum multiple criteria - When your data is formatted as a Table - When you need to sum values from non-adjacent cells and - Summing from different sheets We also go over what things to keep in mind to avoid errors in your SUMIFS formulas. Click here if you would like to read our step by step article on this: https://yacostasolutions.com/sumifs-excel/ If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/ *FYI: This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365 The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊 To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube Thanks! *DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support! #YAcostaTutorials

Category