View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default 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?