Google Sheets offers many of the same features as Microsoft Excel. The SUMIF function allows you to quickly sum rows that meet certain criteria.

New to Google Sheets? This guide walks you through the basics of how to use Google Sheets, from creating a new sheet to entering and formatting data.

The sheet contains some duplicate name entries which we are going to find and highlight using the COUNTIF function and conditional formatting in Google Sheets.