Count a column
 

Hello,

I use the following formula to mark an "X" in a column of cell when there is
content in a series of other cells.

What formula do I se to count the "X?" What I'm using now counts the
furmula entry.

Thanks

Count a column
 

Let's say that column A has X's in some cells and blanks in other cells
=COUNTIF(A:A,"X")
should give you what you need
--
Gary''s Student - gsnu200822


"Jim" wrote:

Hello,

I use the following formula to mark an "X" in a column of cell when there is
content in a series of other cells.

What formula do I se to count the "X?" What I'm using now counts the
furmula entry.

Thanks

Count a column
 

Try this:

=COUNTIF(D:D,"x")

where I have assumed column D is used for your Xs.

Hope this helps.

Pete

On Dec 31, 2:22*pm, Jim wrote:
Hello,

I use the following formula to mark an "X" in a column of cell when there is
content in a series of other cells.

What formula do I se to count the "X?" *What I'm using now counts the
furmula entry.

Thanks

Count a column
 

Perfect - Thanks

"Gary''s Student" wrote:

Let's say that column A has X's in some cells and blanks in other cells
=COUNTIF(A:A,"X")
should give you what you need
--
Gary''s Student - gsnu200822


"Jim" wrote:

Hello,

I use the following formula to mark an "X" in a column of cell when there is
content in a series of other cells.

What formula do I se to count the "X?" What I'm using now counts the
furmula entry.

Thanks