In this example, we count all cells with content and divide by the number of available cells. In this case, a person's attendance is marked with an? X ?. If we apply the percentage format to the result cell, we will be able to record the percentage attendance rate.
However, sometimes we want to count all cells that have no content. To do this, the function COUNTBLANK is used in Excel . This function shares the same layout as the other two functions already presented, but can only contain one argument. Therefore, you cannot include multiple ranges in a single function, instead you have to add sums.