How to count X's in a column

's Computer Specifications

Hi,

I need to count the number of X's that appear in column B. What would
the best function be to do this?

Many thanks,

Marie

--
Marie1uk
------------------------------------------------------------------------
Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984
View this thread: http://www.excelforum.com/showthread...hreadid=562016

's Computer Specifications

=COUNTIF(B:B,"X")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Marie1uk" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hi,
>
> I need to count the number of X's that appear in column B. What would
> the best function be to do this?
>
> Many thanks,
>
> Marie
>
>
> --
> Marie1uk
> ------------------------------------------------------------------------
> Marie1uk's Profile:
http://www.excelforum.com/member.php...o&userid=20984
> View this thread: http://www.excelforum.com/showthread...hreadid=562016
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to count#cells w/= value in other column and not count blank c	aganoe	Microsoft Excel Worksheet Functions	4	9th Apr 2010 11:36 AM
Count Unique Values in 1 Column based on Date Range in another Column	Brian	Microsoft Excel Worksheet Functions	0	16th May 2009 04:44 PM
Count Intervals of 1 Numeric value in a Row and Return Count down Column	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	8	4th Oct 2005 04:37 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	9	31st Jul 2005 03:37 AM
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE.	=?Utf-8?B?d2l0Y2hjYXQ5OA==?=	Microsoft Excel Worksheet Functions	1	4th Feb 2005 01:38 PM