Excel, Data, Data Analysis, Analytics.
function to count cells that contain numbers in column B. COUNTA() COUNTA() counts ALL non-empty cells, regardless of their data type. How does this compare with COUNT()? COUNT() only counts cells that contain numeric values, whereas COUNTA() counts all non-empty cells, regardless of type. If a