| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a single value across multiple cell groups | Excel Discussion (Misc queries) | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| Counting single instances in a column | Excel Discussion (Misc queries) | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
| Counting Expression in a Single formula | Excel Worksheet Functions | |||
Linear Mode
