ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Counting the "x"! (https://www.excelbanter.com/new-users-excel/117789-counting-x.html)

Shelly

Counting the "x"!
 
Please help! I am trying to create a formula that will give me a total of
the x's in a column.

Niek Otten

Counting the "x"!
 
Look in HELP for COUNTIF()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Shelly" wrote in message ...
| Please help! I am trying to create a formula that will give me a total of
| the x's in a column.



George Gee

Counting the "x"!
 


=COUNTIF(A1:A100,"x")

George Gee



"Shelly" wrote in message
...
Please help! I am trying to create a formula that will give me a total of
the x's in a column.





All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com