Help: Counting characters in Excel

  • Thread starter Thread starter alan.estrada.adler
  • Start date Start date
A

alan.estrada.adler

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.
 
Try this:

=COUNTIF(A:A,"x")

I've assumed you have your x's in column A - adjust to suit.

Hope this helps.

Pete
 
If you don't have any other values in that column........

=COUNTA(A:A)

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
counting blank cells within two columns 2
Counting characters in Excel 2
Counting and deleting 7
Count Instances of a Specific Character 2
Use CountIf() with symbols 3
trouble shooting "COUNT" 2
What is wrong with my UDF 4

Back
Top