How do I use Sumifs in Excel with examples?

     The SUMIFS function in Excel is used to calculate the sum of a range based on multiple criteria. It allows you to specify one or multiple criteria ranges and criteria to determine which cells to add. The syntax for the SUMIFS function is as follows:

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

Sum_Range: This is the range of cells that you want to sum.

Criteria_Range1: This is the first range that you want to apply criteria to.

Criteria1: This is the criteria that you want to apply to criteria_range1.

[criteria_range2, criteria2, ...]: Optional additional ranges and criteria that you can specify.

Here's an example to illustrate how to use the SUMIFS function:

    Let's say you have a table with sales data, and you want to calculate the total sales where the product is "Apples" and the salesperson is "John". The table is in columns A (Product), B (Salesperson), and C (Sales Amount).

=SUMIFS(C2:C100, A2:A100, "Apples", B2:B100, "John")

In this example:

sum_range is C2:C100 (Sales Amount column).

criteria_range1 is A2:A100 (Product column), and criteria1 is "Apples".

criteria_range2 is B2:B100 (Salesperson column), and criteria2 is "John".

The SUMIFS function will sum all the sales amounts where the product is "Apples" and the salesperson is "John".

    Remember that you can have multiple criteria ranges and criteria pairs based on your specific requirements.