Tag: Calc

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