SUMIFS Examples in Excel

Add to Favorites
Author: | Edits: don

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 Function: SUMIFS()
Downloadable Files: Excel File

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...
Wildcards in Excel
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...
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...
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...
Sum the Visible Rows from a Filtered List in Excel
Tutorial: How to SUM only the visible rows from a filtered data set in Excel. To do this, we will us...
Tutorial Details
Excel Function: SUMIFS()
Downloadable Files: Excel File
Similar Content
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...
Wildcards in Excel
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...
Excel Forum