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

I think MS was having trouble with the newsservers for a few hours.

Thanks for responding Dave. Maybe the trouble they were having had to do
with purging all those MI5 spam messages that were posted earlier.g

Rick

Thanks for responding Biff. Strange... I saw my own response quite quickly,
but no one else's for a long time.

Rick


"T. Valko" wrote in message
...
I saw a delay.

Using OE, there were no replies posted when I replied. After my reply
didn't show up I started looking around. CDO showed only Chip's reply.
Google Groups also didn't show any replies.

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
Did anyone else see a delay in the posting of the responses to this
thread? When I answered the OP, there were no other messages posted to
the thread. I went to eat supper about 25 minutes ago and I was the only
message posted in this thread. I just came back, refreshed the newsreader
and... whoom... nine messages popped up.

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

You're welcome. Thanks for the feedback!

Have a great and prosperous New Year!

--
Biff
Microsoft Excel MVP


"paljowestsub" wrote in message
...
Thank you for your help, especially on New Year's Day! That did it.
--
JP


"T. Valko" wrote:

Try this:

=COUNTIF(A1:J1,"x")

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"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

When I responded there were NO responses shown to me.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
Thanks for responding Biff. Strange... I saw my own response quite
quickly, but no one else's for a long time.

Rick


"T. Valko" wrote in message
...
I saw a delay.

Using OE, there were no replies posted when I replied. After my reply
didn't show up I started looking around. CDO showed only Chip's reply.
Google Groups also didn't show any replies.

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
Did anyone else see a delay in the posting of the responses to this
thread? When I answered the OP, there were no other messages posted to
the thread. I went to eat supper about 25 minutes ago and I was the only
message posted in this thread. I just came back, refreshed the
newsreader and... whoom... nine messages popped up.

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