Excel Forum

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.