COUNTA or COUNTIF??

J

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!
 
D

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

Jayme

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

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top