Excel Tutorial – SUMIFS

The SUMIFS function in Microsoft Excel is a powerful tool that allows you to sum values in a range of cells based on multiple criteria. It is a useful function to use when you want to sum values that meet specific conditions, such as values that are greater than or equal to a certain number, or values that contain a specific text string.

Here is a step-by-step tutorial on how to use the SUMIFS function in Microsoft Excel:

1. Open a new or existing spreadsheet in Microsoft Excel.
2. Identify the range of cells that you want to sum. This is known as the sum range.
3. Determine the criteria that you want to use to sum the values in the sum range. You can specify multiple criteria by separating them with commas.
4. Select the cell where you want to enter the SUMIFS function.
5. Type the =SUMIFS( formula and press the Enter key.
6. In the SUMIFS formula, enter the sum range as the first argument.
7. For each criterion, enter the range of cells to test as the second argument, followed by the criterion itself as the third argument. For example, if you want to sum values that are greater than or equal to a certain number, you can use the ">=" operator as the criterion. If you want to sum values that contain a specific text string, you can use the "*text*" operator as the criterion.
8. Press the Enter key to complete the SUMIFS function. The sum of the values in the sum range that meet the specified criteria will be displayed in the selected cell.

Here is an example of a SUMIFS formula:

=SUMIFS(A2:A5, B2:B5, ">=10", C2:C5, "John")

This formula sums the values in the range A2:A5 based on the following criteria:

• The value in the corresponding cell in the range B2:B5 is greater than or equal to 10.
• The value in the corresponding cell in the range C2:C5 is “John”.

If a cell in the range A2:A5 meets both of these criteria, it is included in the sum.

You can also use the SUMIFS function to sum values based on dates. To do this, you can use the ">=" and "<=" operators to specify a date range.

For example, if you want to sum values that are in the range A2:A5 and have a date in the range D2:D5 that falls between January 1, 2020 and December 31, 2020, you can use the following SUMIFS formula:

=SUMIFS(A2:A5, D2:D5, ">=01/01/2020", D2:D5, "<=12/31/2020")

I hope this tutorial helps you understand how to use the SUMIFS function in Microsoft Excel. It is a powerful tool that can help you sum values that meet specific criteria within a range of cells.