How to Use SUMIF From Another Sheet in Excel

Using SUMIF from another sheet in Excel allows you to add up values in a range based on a specified criteria from a different worksheet. Here's a step-by-step guide on how to use SUMIF from another sheet in Excel:

1. Open your Excel workbook and have both the sheets you want to work with open.
2. Click on the cell in the destination sheet where you want the SUMIF result to be displayed.
3. Type the following formula: =SUMIF(Sheet1!A:A, B1, Sheet1!C:C) In this example formula:
   • Sheet1!A:A refers to the range in the source sheet (Sheet1) where the criteria will be applied
   • B1 refers to the cell containing the criteria in the destination sheet
   • Sheet1!C:C refers to the range in the source sheet (Sheet1) that you want to sum
4. Replace Sheet1, A:A, B1, and C:C with the appropriate sheet name and cell references that match your specific data.
5. Press Enter to apply the formula. The result of the SUMIF function from the other sheet will now be displayed in the destination sheet.

Example

Assume you have two sheets in Excel: "SalesData" and "Summary". In the "SalesData" sheet, you have the following data:

In the "Summary" sheet, you want to find the total revenue for "Product A" in the "East" region. You would use the following steps:

1. In the "Summary" sheet, type "Product A" in cell A1 and "East" in cell B1.
2. Click on the cell where you want the SUMIF result (e.g., C1).
3. Type the following formula: =SUMIF(SalesData!A:A, A1, SalesData!C:C)
4. Press Enter.

The result in cell C1 should be 2500, which is the total revenue for "Product A" in the "East" region.