How to SUMIF from another sheet
✓ Verified in LibreOffice 25.8.7.3Conditionally total data that lives on a different tab — a summary sheet reading a data sheet.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =SUMIF(Data!A:A,"East",Data!B:B) | Prefix every range with the sheet name. All ranges must be on the SAME other sheet and the same size. |
| Google Sheets | =SUMIF(Data!A:A,"East",Data!B:B) | Identical. |
| LibreOffice Calc | =SUMIF(Data.A:A,"East",Data.B:B) | LibreOffice uses a dot: Data.A:A. |
How it works
A cross-sheet SUMIF is an ordinary SUMIF with each range prefixed by the source tab: the two East rows on the Data sheet total 100 + 25 = 125. The criteria range and sum range must both live on that same sheet and match in size. Excel and Google Sheets write Data!A:A; LibreOffice writes Data.A:A (dot). SUMIFS, COUNTIF, and AVERAGEIF all take cross-sheet ranges the same way. Verified by running the formula against a real second tab.
Verified, not just documented
We ran =SUMIF(Data!A1:A3,"East",Data!B1:B3) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 125 — exactly the expected result. Every formula here is confirmed by actually executing it.