That's where Google Sheets' SUMIF function comes in. You can use SUMIF to calculate a sum based on a condition. That condition can be built into the set of values themselves, or numbers that are ...

Using Sum in Functions: Highlight the cells where you want to sum. Locate the Functions button (Σ) on the toolbar. Choose SUM, Google Sheets will sum the range you want based on the highlighted ...