Excel, Data, Data Analysis, Analytics.
cell contains the value “INCOMPLETE”, the COUNTA() function WOULD include this in its count, but the COUNT() function would NOT. Below, I have the same list of students and scores as in the example for COUNT(). The COUNT() function gave me a result of 7 because it did NOT count the “INCOMPLETE”