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

You can try
=COUNTIF(A1:A4,"X")

"Lee" wrote:

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

=COUNTIF(A1:d1,"x")

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

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=538439

Hopefully this is what you are looking for.

=COUNTIF(A1:D1,"=X")

HTH

RC


--
JRockdown
------------------------------------------------------------------------
JRockdown's Profile: http://www.excelforum.com/member.php...o&userid=13236
View this thread: http://www.excelforum.com/showthread...hreadid=538438