SUMIFS

Excel SUMIFS Function

A pre-made Excel function called SUMIFS determines the sum of a range depending on one or more true or false conditions.

The typeface is =SUMIFS:

				
					=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2] ...)

The conditions are referred to as criteria1, criteria2, and so on, which can check things like:

The ranges where the function checks for the conditions are criteria_range1, criteria_range2, and so on.

The range in which the function computes the sum is called the [sum_range].

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

The symbol is determined by your language preferences.

Find the total stats for a Pokemon of the first generation that is Water type:

The requirements are “Water” as the type and “1” as the generation.

Note: The full dataset continues after row 14, all the way down to row 759.

Example SUMIFS function, step by step:

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

5. Type ,

6. Specify the range for the first condition B2:B759 (the Type 1 values)

7. Type ,

8. Specify the criteria (the cell F3, which has the value “Water”)

9. Type ,

10. Specify the range for the second condition D2:D759 (the Generation values)

11. Type ,

12. Specify the criteria (the cell G3, which has the value “1”)

13.Hit enter

Note: Before pressing enter, repeat steps 9 through 12 to add more conditions.

The code now determines the Pokemon of the first generation that are Water type, adding up all of their data.

To compare the following Generations, the function can be repeated:

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

The overall stats of every Water type Pokemon across generations are now visible to us: