I need a formula

[Lee]

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

[Dav]

=COUNTIF(A1:d1,"x")

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

regards

Dav

[Miguel Zapico]

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