Ask Your Question

Calc function "counta" not working [closed]

asked 2012-12-01 13:05:18 +0100

Fayaz gravatar image

updated 2015-10-19 14:02:29 +0100

Alex Kemp gravatar image

Hi there,

I need help in figuring out how to use the "counta" function in Calc. I tried many different ways to count string values but failed without any luck.

I am using LibreOffice 3.6.3

Can anyone help me.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 14:03:25.332475

3 Answers

Sort by » oldest newest most voted

answered 2012-12-20 09:41:29 +0100

Fayaz gravatar image

Thank you ROSt52 & mariosv

What I need to know now, when using COUNTA function, will I be able to count from an array that contains a specific string value. I used to use the following function in MS Office. How can I get the same result in Libre Office


edit flag offensive delete link more

answered 2012-12-01 18:48:08 +0100

m.a.riosv gravatar image

image description

edit flag offensive delete link more

answered 2012-12-02 02:35:11 +0100

ROSt52 gravatar image

updated 2012-12-02 02:44:41 +0100

I am not sure if I understand your question well, but I am of the impression that you might misinterprete the what you need to do when opening the function wizard for COUNTA


For each value x you can indicate an array of cells, however, if you have only 1 array you only need the value 1. Click on the button on the right side and select the array of cell for which you want to count the number of entries. This is what was done in the first answer by mariosv to your question.

I added my answer because I am of the impression you struggle with the value 1, value2 ,.... I had before the same problem.

edit flag offensive delete link more

Question Tools


Asked: 2012-12-01 13:05:18 +0100

Seen: 1,896 times

Last updated: Dec 20 '12