SUMIF : HOW TO USE SUMIF FUNCTION IN EXCEL

SUMIF

Like all Excel functions ‘SUMIF’ consist of some elements you need to put into it to make it put out the results you desire. This concept is called ‘Syntax’.

‘SUMIF’

The syntax for the ‘SUMIF’ function is pretty straight forward:

‘=SUMIF(range, criteria, [sum_range])’

The ‘range’ parameter is actually the range of cells that will be evaluated by the ‘criteria’ parameter.
The ‘criteria’ parameter is the condition that must be met in the ‘range’ parameter. For instance, if our ‘range’ was a column that listed t-shirt color, a value like ‘red’ or ‘white’ could be our ‘criteria’. The ‘criteria’ value can be text, a number, a date, a logical expression, a cell reference, or even another function.
*One thing to note, however, is that any mathematical expression must be enclosed in double quotes as we will see when we cover using comparison operators.
The ‘sum_range’ parameter is optional as noted by the brackets. This simply means that if omitted, the ‘sum_range’ will default to the same cells you chose for the ‘range’ parameter.

The syntax of ‘SUMIFS’ is as follows:

‘=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)’

Notice that the primary difference compared to ‘SUMIF’ that is immediately obvious is the first, and required, argument in ‘SUMIFS’.
Unlike the ‘SUMIF’ function, ‘sum_range’ in ‘SUMIFS’ is required.
Following this first parameter is the first criteria range and criteria pair, ‘criteria_range1’ and ‘criteria1’.
Clearly, this pair of parameters is required since without at least one of these, the function itself is useless. As requirements present the need for more of these criteria range/criteria pairs, we can add as many as necessary up to the limit of 127 pairs.
The basic gist of how to make use of these parameters holds true to that of ‘SUMIF’, so we will not repeat those same basic concepts.