COUNTA function in Calc

Discuss the spreadsheet application
Post Reply
maawe
Posts: 2
Joined: Tue Oct 24, 2017 12:13 pm

COUNTA function in Calc

Post by maawe »

Hi.

I am trying to analyse the info in my spreadsheet.

First I would like to sum up the total number of enteries in the "A" Column of my spreadsheet.

I have tried using " =COUNTA (A1: A99) "formula but get the fail code "#NAVN? "

I don't understand what I am doing wrong could someone please help?

Also I would like calc to total up the number of each symbol in a column. I have use the symbols "√" and "X".
Does anyone have a smart way to do this please?


thankyou
maawe
open office 4.1.3, Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: COUNTA function in Calc

Post by RoryOF »

I've just tried =COUNTA(a1:a5); it works correctly for me with any combination I have tested of entries in the range, be they numeric. strings or calculation results. It does not count blank cells.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
maawe
Posts: 2
Joined: Tue Oct 24, 2017 12:13 pm

Re: COUNTA function in Calc

Post by maawe »

Thankyou RoryOF,

I copied and pasted your formula into the spread sheet but I still get #NAVN?

Should I try reinstalling OpenOffice?
open office 4.1.3, Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: COUNTA function in Calc

Post by RoryOF »

If you are getting a #NAVN? error message, then probably COUNTA should be in a different language or else you need to change your locale to English.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: COUNTA function in Calc

Post by robleyd »

It might be Error 525 - NAVN = NAME perhaps in Danish or Norwegian; Google translate seemed unsure.

For the other question, COUNTIF might be a solution - but I have no idea what that is in either language.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
DiGro
Posts: 173
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: COUNTA function in Calc

Post by DiGro »

Could it be that there are spaces in the formula ?

Code: Select all

=COUNTA (A1: A99)
should in fact be

Code: Select all

=COUNTA(A1:A99)
:ugeek:
____________
DiGro

AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: COUNTA function in Calc

Post by RoryOF »

I tried with some spaces in the formula; they seemed to make no difference.
I'm fairly sure it is use of COUNTA (English) in place of its equivalent in the installation language, because of the language of the error message..
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
DiGro
Posts: 173
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: COUNTA function in Calc

Post by DiGro »

Well, looking at the table for translations in MS, which probably are the same voor Ooo/AOo /LO,
then it probably should be:

Norwegian English
ANTALLA COUNTA Teller hvor mange verdier som er i argumentlisten

Code: Select all

=ANTALLA(A1:A99)
____________
DiGro

AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
Post Reply