Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help: Counting characters in Excel
Good morning.
I have a spreadsheet with a column where I'll put an x if a condition is fullfilled, is there a function so I can count how many x's are in that column? thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help: Counting characters in Excel
Try this:
=COUNTIF(A:A,"x") I've assumed you have your x's in column A - adjust to suit. Hope this helps. Pete On Jan 30, 5:36*pm, wrote: Good morning. I have a spreadsheet with a column where I'll put an x if a condition is fullfilled, is there a function so I can count how many x's are in that column? thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help: Counting characters in Excel
If you don't have any other values in that column........
=COUNTA(A:A) Vaya con Dios, Chuck, CABGx3 " wrote: Good morning. I have a spreadsheet with a column where I'll put an x if a condition is fullfilled, is there a function so I can count how many x's are in that column? thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Characters | Excel Worksheet Functions | |||
counting characters in a cell | Excel Discussion (Misc queries) | |||
Counting characters | Excel Discussion (Misc queries) | |||
counting characters in a line | Excel Discussion (Misc queries) | |||
Counting Characters in a Cell | Excel Worksheet Functions |