Apache OpenOffice Community Forum

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

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.

Thankyou RoryOF,

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

Should I try reinstalling OpenOffice?

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.

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.

Could it be that there are spaces in the formula ?
should in fact be

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..

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