Counting X's in a single column
 

Is there a formula for doing anything like this...
I have a column where I place an X meaning this is a new client
At the end of the day, I need to know how many new clients I have taken that
day. Is there a formula that will count all of the X's for me in that column?

Counting X's in a single column
 

=COUNTIF(A1:A10,"X")

change the range to suit your need.

Gaurav

"Nocturnica" wrote in message
...
Is there a formula for doing anything like this...
I have a column where I place an X meaning this is a new client
At the end of the day, I need to know how many new clients I have taken
that
day. Is there a formula that will count all of the X's for me in that
column?

Counting X's in a single column
 

That helps me so much, thank you! Works perfectly

Nocturnica

"Gaurav" wrote:

=COUNTIF(A1:A10,"X")

change the range to suit your need.

Gaurav

"Nocturnica" wrote in message
...
Is there a formula for doing anything like this...
I have a column where I place an X meaning this is a new client
At the end of the day, I need to know how many new clients I have taken
that
day. Is there a formula that will count all of the X's for me in that
column?

Counting X's in a single column
 

Happy to Help :)


"Nocturnica" wrote in message
...
That helps me so much, thank you! Works perfectly

Nocturnica

"Gaurav" wrote:

=COUNTIF(A1:A10,"X")

change the range to suit your need.

Gaurav

"Nocturnica" wrote in message
...
Is there a formula for doing anything like this...
I have a column where I place an X meaning this is a new client
At the end of the day, I need to know how many new clients I have taken
that
day. Is there a formula that will count all of the X's for me in that
column?