Count a column

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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
 
Try this:

=COUNTIF(D:D,"x")

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

Hope this helps.

Pete
 
Back
Top