Excel Forum
Similar Content
SUMIFS - Sum Values Based on Multiple Criteria in Excel
Tutorial: The SUMIFS function allows you to sum values that meet multiple criteria across multiple ...
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...
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...

Excel Magic Trick #203: SUMIF function formula 21 Examples

See methods for summing with criteria: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an amount, values form a specific sales Representative, values that have no Sales Representative, the use of wildcards for criteria, and more!
Learn about the syntax that the SUMIF function uses and see different methods to achieve the same goal.

Got a Question? Ask it Here in the Forum.