COUNTA or COUNTIF??

[Jayme]

I am trying to count the # of times a name appears in a column. If I use
COUNTA, it counts the # of filled cells. COUNTIF just gives me and error
message.
I am using Office.org Calc, if that makes any difference

Please help!

 

[Don Guillett]

This is an Excel ng. Countif would be the function in Excel.

 

[Dave Peterson]

What formula did you use with =countif().

=countif(a:a,"Jayme")

If it's something like that, then it appears that Calc doesn't like that
function.

Maybe you could use a helper column:
=if(a1="jayme",1,0)
and drag down

Then sum that helper column.

 

[Matthewjd]

Countif should work. Show us your formula so we can help.

 

[Jayme]

I still get the same error. what does 1,0 stand for??

 

[Jayme]

=COUNTIF(F6:F88,"Laura") I have used comma and semi-colon, single quotes and
double quotes, with and without stars. I am stuck

 

[Don Guillett]

I just went to calc and tested. I used a semi colon as shown
=countif(f6:f88;"Laura")
Maybe you need to trim leading/trailing spaces

 

[Dave Peterson]

1 and 0 are numbers.

That way you can add them.

What formula did you try?

Do you have any formula that works? Please share it if you do.