![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 07:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com