ExcelBanter - Counting non-numeric values

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/171241-re-counting-non-numeric-values.html)

Ron Coderre

Counting non-numeric values

Try something like this:

=COUNTIF(A1:Z1,"X")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"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

paljowestsub

Counting non-numeric values

Thank you very much! That did it!
--
JP

"Ron Coderre" wrote:

Try something like this:

=COUNTIF(A1:Z1,"X")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"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:43 PM.