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

Niek Otten

Counting non-numeric values

Hi Joe,

Look in HELP for the COUNTIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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!
--
JP

"Niek Otten" wrote:

Hi Joe,

Look in HELP for the COUNTIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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