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
COUNTA function in Calc
COUNTA function in Calc
open office 4.1.3, Windows 10
Re: COUNTA function in Calc
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
Re: COUNTA function in Calc
Thankyou RoryOF,
I copied and pasted your formula into the spread sheet but I still get #NAVN?
Should I try reinstalling OpenOffice?
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
Re: COUNTA function in Calc
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
Re: COUNTA function in Calc
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.
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
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: COUNTA function in Calc
Could it be that there are spaces in the formula ?
should in fact be
Code: Select all
=COUNTA (A1: A99)
Code: Select all
=COUNTA(A1:A99)
____________
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
Re: COUNTA function in Calc
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..
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
Re: COUNTA function in Calc
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
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)
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)