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.

Jayme wrote:

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

"Dave Peterson" wrote:

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.



Jayme wrote:

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!

--

Dave Peterson


--

Dave Peterson