Formula Help for Excel: SUMIF

An Excel formula that is commonly used for many spreadsheet applications is the SUMIF command. This code is beneficial for people who require finding out a sum from a vast table of data but for a specific criteria, for example the total sales made by an employee, or total sales made from an area of the country.

The SUMIF formula help tab that appears on the software shows the following guideline text:

=SUMIF(range, criteria, [sum_range])

We will go through each of these criteria now so that a full understanding of the formula can be grasped.

Range:

The range of data that is required to be searched needs to be stated. So for example if we required the name of an employee to analyse their sales figures, then the column ‘Name’ would be selected. (In the below example the following would need to be input: B4:B16)

SUMIF formula
SUMIF formula

[space10]

Criteria:

The ‘criteria’ component of the formula is simply the phrase or value that you are searching for. In the working example the name required to search for is James, so the criteria to be entered in the formulae has to be entered. Such criteria has to be encapsulated by quotation marks so that excel can identify that it is a word that needs to be searched, for example “James”. (as shown below)

SUMIF Formula
SUMIF Formula

[space10]

Sum Range:

The final part of the formula is required to tell excel what cells need to be added together fror the previously stated criteria (i.e. the total amount of sales that James achieved). The range of cells that the values can be found in must now be highlighted for the software top search the data and sum together the required information. The image below shows this in the working example:

SUMIF Formula
SUMIF Formula

[space10]

Once the formula has been entered, excel give the sum of the sales achieved by James as stated in the table. The SUMIF formula is a useful tool for searching large lists of information that aren’t organised in a specific way.

SUMIF Formula
SUMIF Formula

[space10]

For those who require formula help for excel, see our tips and tricks page for a range of assisstance for similar formula problems.