However, the problem starts when you go to count the empty cells of a large spreadsheet. That is when you can use this trick to get the exact number of blank cells in Google Sheets or Excel.

Here's a quick and dirty formula you can use in Google Sheets to get a running count of cells that contain any value (numbers, dates, text, links, etc.).

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.