COUNTA function in Calc

Discuss the spreadsheet application

COUNTA function in Calc

Postby maawe » Tue Oct 24, 2017 12:21 pm

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
maawe
 
Posts: 2
Joined: Tue Oct 24, 2017 12:13 pm

Re: COUNTA function in Calc

Postby RoryOF » Tue Oct 24, 2017 12:45 pm

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.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25401
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: COUNTA function in Calc

Postby maawe » Tue Oct 24, 2017 1:18 pm

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
maawe
 
Posts: 2
Joined: Tue Oct 24, 2017 12:13 pm

Re: COUNTA function in Calc

Postby RoryOF » Tue Oct 24, 2017 1:23 pm

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.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25401
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: COUNTA function in Calc

Postby robleyd » Tue Oct 24, 2017 1:30 pm

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
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1021
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: COUNTA function in Calc

Postby DiGro » Tue Oct 24, 2017 4:27 pm

Could it be that there are spaces in the formula ?

Code: Select all   Expand viewCollapse view
=COUNTA (A1: A99)


should in fact be

Code: Select all   Expand viewCollapse view
=COUNTA(A1:A99)


:ugeek:
____________
DiGro

AOO 4.1.4 on Windows 10. Scanned with ZIGGO Extended security (F-Secure)
User avatar
DiGro
 
Posts: 58
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: COUNTA function in Calc

Postby RoryOF » Tue Oct 24, 2017 4:40 pm

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.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25401
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: COUNTA function in Calc

Postby DiGro » Tue Oct 24, 2017 5:14 pm

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   Expand viewCollapse view
=ANTALLA(A1:A99)
____________
DiGro

AOO 4.1.4 on Windows 10. Scanned with ZIGGO Extended security (F-Secure)
User avatar
DiGro
 
Posts: 58
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands


Return to Calc

Who is online

Users browsing this forum: Google [Bot], RPG and 21 guests