Fill Blank Cells in Excel Using Dynamic Array Functions Watch this video on YouTube. Expand your understanding of Excel functions with additional resources from our extensive library of articles.

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.

3. Repeat the value above in Excel Depending on where you receive your data, you might find that some blank cells should contain the value in the cell above.