Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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
Similar Content on TeachExcel
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...
Sum Values that Meet 1 of Multiple Conditions in Excel
Tutorial: How to sum values that equal one of many potential criteria; this is basically summing wi...
Tutorial: How to sum values that equal one of many potential criteria; this is basically summing wi...
SMALL Function - Get the Lowest Values from a List in Excel
Tutorial: Return the smallest values from a list, or any of the smallest values, in Excel. This inc...
Tutorial: Return the smallest values from a list, or any of the smallest values, in Excel. This inc...
LARGE Function - Get the Highest Values from a List in Excel
Tutorial: Return the largest value from a list, or any of the top values, in Excel. This method use...
Tutorial: Return the largest value from a list, or any of the top values, in Excel. This method use...
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT function on a filtered list of data so that hidden rows are not incl...
Tutorial: How to use the COUNT function on a filtered list of data so that hidden rows are not incl...