What should you do instead? Here’s where an apparently ill-suited Excel function, SUMPRODUCT, can help. At first, it may not seem like an ideal fit. SUMPRODUCT’s syntax [SUMPRODUCT ...

There are some functions called COUNTBLANK, COUNTIF, SUMPRODUCT, etc. that will help you to count blank or empty cells. Sometimes, you may need to count all empty cells in a spreadsheet.