Learn how to count blank or empty cells in Excel and Google Sheets. Use COUNTBLANK , COUNTIF or SUMPRODUCT function to count blank cells in spreadsheet.

1. Open Google Sheets in a web browser and click the cell in which you want the formula's answer to appear. 2. Find the Formula Bar above the spreadsheet. It's a blank field to the right of the Fx ...