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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 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.)
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...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)