SUMIF

Excel SUMIF Function

Excel’s built-in SUMIF function determines the total of items inside a range depending on whether a condition is true or false.

The text is written as =SUMIF:

				
					=SUMIF(range, criteria, [sum_range])

The condition is referred to as criteria, which can check things like:

The [sum_range] is the range where the function calculates the sum.

Recall that the [sum_range] is a choice.

The function computes the sum of the same range as the condition if it is not supplied.

Note: A symbol, such as a , or ; is used to separate the various components of the function;

The symbol is determined by your language preferences.

Calculate the total stats of a Pokemon that is grass-type:

The type must be “Grass” in order to qualify.

Example SUMIF function, step by step:

4. Specify the range for the condition B2:B10 (the Type 1 values)

5. Type ,

6. Specify the criteria (the cell E3, which has the value “Grass”)

7. Type ,

8. Specify the range for the sum C2:C10 (the Total values)

9. Type ,

10. Hit enter

The code now adds up all of the stats for Pokemon that are grass-type.

To compare the other Pokemon types, just repeat this function:

Note: For the remaining rows, you can use the filling function; however, you must use absolute references for the ranges.

At this point, the overall stats for each of the various Pokemon types are visible to us: