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 ...

How to use COUNTIF with a text condition. The COUNTIF function can also sum items based on text criteria. If you needed to find out how many items in a list have a particular color, you would do this: ...