How to use the SUMIF function in Google Sheets. As the name of the function implies, SUMIF is conditional and checks for a status using the IF function before totaling your numbers.