Discussion Locked

Excel Spread Sheet

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

If I have a column of X's. What is the formula to count those X's?
Example:
X
X
X
X

X
X
=Formula here

3 replies

by syscokid

If it's a column of ALL X's (no spaces, no other characters:

Count(A1:A99)

Substitute your own range for (A1:A99).

If there are blanks or other characters:

Countif(A1:A99, "X")

This discussion is closed to new replies.