Microsoft Excel SUMIF Function Help

SUMIF Function Definition

Adds the cells in a column or row that match a specific criteria.

SUMIF Function Syntax

=SUMIF(range,criteria,[sum_range])

SUMIF Function Argument Definitions

range: This is the row or column that you want evaluated by criteria.

criteria: This is the criteria that will be used to scan the designated row or column. It can be in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 16, "XT", ">32", or "Widget1".

sum_range: This the column or row that contains the cells to be added. Their row or column position must match the cell positions used in the range argument (see below). If sum_range is omitted, the cells in range are both evaluated by criteria and added if they match criteria.

SUMIF Function Tips

• The key to using this function is that the number of cells in the range and sum_range arguments must count to the same number. They do not have to occupy the same row or column space. For example, You could scan A1:A10 and add A11:A20 because A1 and A20 are in position 1 an so forth.
• You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) preceding the character.
• To analyze data in a list based on criteria, such as profit margins or product types, also use the database and list management functions (DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARP).

SUMIF Function Examples

• Click here to view SUMIF function examples