Tag: 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 […]