Tagged with COUNTA function

COUNTA() function in OpenOffice

Just discovered the COUNTA() function in OpenOffice (probably also in other spreadsheets like M$ Excel). This enables you to count the number of cells that contain any text, unlike COUNT(), which only counts cells that have content in numbers (e.g. “2,4,6, eight” would return “3”). The same sequence using COUNTA() returns “4”. I found this … Continue reading