Microsoft Excel SUMIF Function Help
EMAGENIT Home page

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

 

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