Count a column

[Jim]

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

 

[Gary''s Student]

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

 

[Pete_UK]

Try this:

=COUNTIF(D,"x")

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

Hope this helps.

Pete

 

[Jim]

Perfect - Thanks

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