SUMIFS Examples in Excel
Excel tutorial for the SUMIFS function - this includes 15 different examples that show you everything from very simple number and text matching SUMs to complex SUMs with mutliple conditions, comparison operators, and wildcards.
This includes the * ? ~ wildcards and how to use them in the function as well as the not-equals-to comparison operator and how to put them all together to make a powerful multi-condition function.
Question? Ask it in our Excel Forum
- Skill Level: All Levels
- |
- 5 hours+
How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.
- Skill Level: All Levels
- |
- 2 hours
Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...
Tutorial: How to sum values that equal one of many potential criteria; this is basically summing wi...
Tutorial: Return the smallest values from a list, or any of the smallest values, in Excel. This inc...
Tutorial: Return the largest value from a list, or any of the top values, in Excel. This method use...
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
