What is COUNTBLANK function in Excel? COUNTBLANK function is one of Statistical functions in Microsoft Excel used to count the number of empty cells in a range of cells. Syntax of COUNTBLANK function COUNTBLANK(range) The COUNTBLANK function syntax has the following arguments: Range Required. The range from which you want to count the blank cells. COUNTBLANK formula explanation Cells with formulas that return “” (empty text) are also…
Tag: COUNTBLANK function
Highlight rows with blank cells in Excel
This tutorial shows how to Highlight rows with blank cells in Excel using the example below; Formula =COUNTBLANK($B5:$F5) Explanation To highlight rows that contain one or more blank cells. you can conditional formatting with a simple formula based on the COUNTBLANK function. In the example shown, the range B5:F15 is formatted with a conditional formatting rule based on this formula: =COUNTBLANK($B5:$F5)…
Return blank if in Excel
This tutorial shows how to calculate Return blank if in Excel using the example below; Formula =IF(A1=1,B1,””) Explanation To return a blank result using the IF function, you can use an empty string (“”). In the example shown, the formula in D5 (copied down) is: =IF(B5=1,C5,””) How this formula works This formula is based on the IF function, configured with a simple logical…
Count cells that are not blank in Excel
This tutorial shows how to Count cells that are not blank in Excel using the example below; Formula =COUNTA(range) Explanation To count the number of cells that are not blank in a range, you can use the COUNTA function. In the example shown, E5 contains this formula: =COUNTA(B4:B8) How this formula works COUNTA is fully automatic. When given a range of…
Count cells that are blank in Excel
This tutorial shows how to Count cells that are blank in Excel using the example below; Formula =COUNTBLANK(range) Explanation To count the number of cells that are blank, you can use the COUNTBLANK function. In the example, the active cell contains this formula: =COUNTBLANK(B4:B8) How this formula works COUNTIF counts the number of cells in the range that don’t contain any value…