Excel, Data, Data Analysis, Analytics.
cells. The COUNTA() function gives me a result of 10 because it DOES include the “INCOMPLETE” cells. Let’s look at the COUNTA formula in more depth. Below, I use the formula =COUNTA(B2:B11) “COUNTA” says I want to count all non-empty cells, regardless of data type. “B2:B11” specifies the cells I