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

The syntax for the SUMIF function is: =SUMIF(range, criterion, ... A4 refers to the cell in your summary sheet containing the ...

Fortunately, the SUMIF() function can handle both. Summing only the negative values in a range of values sounds like a difficult task, but there’s a simple solution-use SUMIF().