# How to Use SUMIF From Another Sheet in Google Sheets

Using SUMIF from another sheet in Google Sheets allows you to sum values in a range based on a specific condition from a different sheet. Here's a step-by-step guide on how to achieve this:

Step 1: Prepare your data

- Make sure you have two sheets in your Google Sheets document (e.g., Sheet1 and Sheet2).
- Sheet1 will have the data you want to sum, and Sheet2 will have the criteria for summing the data.

Step 2: Use the SUMIF function

- Go to Sheet2 where you want to display the result.
- Click on the cell where you want to display the sum.
- Type the following formula:

`=SUMIF(Sheet1!A:A, "Criteria", Sheet1!B:B)`

Replace "Criteria" with the condition you want to use for summing the values. You can also use a cell reference.

For example, if you have the following data in Sheet1:

Product | Sales |
---|---|

A | 100 |

B | 150 |

A | 200 |

C | 120 |

B | 180 |

And you want to sum the sales of product A in Sheet2:

#### Example

`=SUMIF(Sheet1!A:A, "A", Sheet1!B:B)`

This formula will sum the sales of product A from Sheet1 and display the result in the cell you typed the formula in on Sheet2.

You can also use a cell reference instead of directly typing the criteria in the formula. For example, if cell A1 in Sheet2 contains the product name "A", you can use the following formula:

`=SUMIF(Sheet1!A:A, A1, Sheet1!B:B)`

Now, the formula will sum the sales of product A from Sheet1 based on the value in cell A1 of Sheet2.