# 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:

- Open your Excel workbook and have both the sheets you want to work with open.
- Click on the cell in the destination sheet where you want the SUMIF result to be displayed.
- 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

- Replace
`Sheet1`

,`A:A`

,`B1`

, and`C:C`

with the appropriate sheet name and cell references that match your specific data. - 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:

A | B | C |
---|---|---|

Product | Region | Revenue |

Product A | East | 1000 |

Product B | West | 2000 |

Product A | East | 1500 |

Product A | West | 1800 |

Product B | East | 1300 |

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

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

- Press Enter.

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

Did you find this useful?