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.