Posted to microsoft.public.excel.misc

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Counting non-numeric values

On Tue, 1 Jan 2008 12:51:01 -0800, paljowestsub
wrote:

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

Look at help for COUNTIF
--ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting non-numeric values	T. Valko	Excel Discussion (Misc queries)	2	January 2nd 08 02:59 AM
Counting non-numeric values	Ron Coderre	Excel Discussion (Misc queries)	1	January 2nd 08 02:40 AM
Counting non-numeric values	Chip Pearson	Excel Discussion (Misc queries)	1	January 2nd 08 02:39 AM
Counting non-numeric values	Rick Rothstein \(MVP - VB\)	Excel Discussion (Misc queries)	0	January 1st 08 11:12 PM
Counting non-numeric values	Don Guillett	Excel Discussion (Misc queries)	0	January 1st 08 10:21 PM

All times are GMT +1. The time now is 08:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us