software

Can I make a cell count the total number of quot;Xquot; placed in a group of cells?
example: If A1, B1, C1, and D1 each have an quot;Xquot;, I want E1 to say quot;4quot;. If A1,
B1, and D1 each have an quot;Xquot;, I want E1 to say quot;3quot;, and so on. Is there a
formula for this?
--
Lee Davenport

You can try
=COUNTIF(A1:A4,quot;Xquot;)

quot;Leequot; wrote:

gt; Can I make a cell count the total number of quot;Xquot; placed in a group of cells?
gt; example: If A1, B1, C1, and D1 each have an quot;Xquot;, I want E1 to say quot;4quot;. If A1,
gt; B1, and D1 each have an quot;Xquot;, I want E1 to say quot;3quot;, and so on. Is there a
gt; formula for this?
gt; --
gt; Lee Davenport


=COUNTIF(A1:d1,quot;xquot;)

note it is not case sensitive so will count X or x

regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=538439
Hopefully this is what you are looking for.

=COUNTIF(A11,quot;=Xquot;)

HTH

RC--
JRockdown
------------------------------------------------------------------------
JRockdown's Profile: www.excelforum.com/member.php...oamp;userid=13236
View this thread: www.excelforum.com/showthread...hreadid=538438