Ask Your Question

COUNTA returns TRUE/FALSE instead of counting cells

asked 2016-04-02 23:11:50 +0100

quaz gravatar image

I want to count the number of cell in selected columns (e.g. COUNTA(B2:L2) ), but instead of returning the number of cells with texts, it just returns FALSE or TRUE (in case there is a cell with the text in range).

It is obviously not the way this function should work. Does anybody have a solution for this issue? My LibreOffice version is

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-04-02 23:21:04 +0100

m.a.riosv gravatar image

Perhaps it's only a format cell issue, test appling [Ctrl+M] to the cell to clear the Boolean format.

edit flag offensive delete link more


thanks, it really was that problem

quaz gravatar imagequaz ( 2017-07-21 12:27:25 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-02 23:11:50 +0100

Seen: 827 times

Last updated: Apr 02 '16