COUNTA or COUNTIF??
 

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!

COUNTA or COUNTIF??
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jayme" wrote in message
...
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!

COUNTA or COUNTIF??
 

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

COUNTA or COUNTIF??
 

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

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

COUNTA or COUNTIF??
 

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

COUNTA or COUNTIF??
 

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

"Matthewjd" wrote:

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

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

COUNTA or COUNTIF??
 

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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

"Matthewjd" wrote:

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

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

COUNTA or COUNTIF??
 

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