Fortunately, Google Sheets offers a range of formulas that ... The syntax for the SUMIF function is: =SUMIF(range, criterion, ...