We need to briefly cover what happens when you merge several cells in Excel or Google Sheets. Or, more specifically, what does not.

This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

To count colored cells in Microsoft Excel, you may use the Find and Select tool or the Excel Filter and SUBTOTAL() function.

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.