ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Counting non-numeric values (https://www.excelbanter.com/excel-discussion-misc-queries/171242-re-counting-non-numeric-values.html)

Rick Rothstein \(MVP - VB\)

Counting non-numeric values
 
Assuming your row is Row 1....

=COUNTIF(1:1,"=x")

Change the two 1's to whatever row number your x's are in.

Rick


"paljowestsub" wrote in message
...
I have a spreadsheet with the letter x in various cells. I want to count
the
number of x's in a particular row of cells. What formula do I use and how
do
I structure the formula?

Thank you!
Joe Palczynski




All times are GMT +1. The time now is 02:23 PM.

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