How-to Guide for Using = SUMIFS

Step 1: Open Google Sheets and create a new spreadsheet. In the first row of the new spreadsheet, create the following column headings in cells A1 to D1 respectively: "Name", "Department", "Month", "Sales".

Step 2: Enter the data from the table above into the corresponding cells in the spreadsheet.

Step 3: To use the =SUMIFS formula, select an empty cell where you want the result to appear. For example, select cell E2.

Step 4: Type the formula =SUMIFS( into the selected cell. Note that the formula requires at least one range and one criterion, but can have multiple ranges and criteria. 

Step 5: Select the range of cells that you want to sum up. In this case, select cells D2 to D10 to sum up the Sales column.

Step 5: Select the range of cells that you want to sum up. In this case, select cells D2 to D10 to sum up the Sales column.

Step 6: Enter a comma , to separate the first range from the first criterion.

Step 7: Select the range of cells that contains the criteria for the first condition. In this case, select cells B2 to B10 to sum up the Sales for a specific department.

Step 8: Enter a comma , to separate the first criterion from the second criterion.

Step 9: Enter the first criterion in quotation marks " " to specify the department to sum up. In this case, enter "Sales".

Step 10: Enter another comma , to separate the second criterion from the third criterion.

Step 11: Select the range of cells that contains the criteria for the second condition. In this case, select cells C2 to C10 to sum up the Sales for a specific month.

Step 12: Enter a comma , to separate the third criterion from the fourth criterion.

Step 13: Enter the third criterion in quotation marks " " to specify the month to sum up. In this case, enter "Mar".

Step 14: Close the formula with a closing parenthesis ). The complete formula should look like this: =SUMIFS(D2:D10,B2:B10,"Sales",C2:C10,"Mar"). 

Step 15: Press Enter on your keyboard to calculate the sum of Sales for the Sales department in March.

Step 16: The result will appear in the selected cell. In this case, cell E2 will display the total sales for the Sales department in March, which is 500. 

You can use this same formula to calculate the total sales for any combination of department and month by changing the values in the criteria fields. Simply replace "Sales" and "Mar" with the department and month that you want to calculate.