total colum using x instesd of numbers what is the formula

G

Guest

Doing a attendence roster. want to use x instead of a number. Don't know the
formula. could use some help
 
G

Guest

If x has been entered into cells in a column and you want to count the number
of x's then try: =COUNTIF(A1:A7,"x")
 
P

Paul B

Chopper-One, how about something like this,

=COUNTIF(A1:A10,"x")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

davesexcel

Chopper-One said:
Doing a attendence roster. want to use x instead of a number. Don't know
the
formula. could use some help
Click to expand...
webdings font
r
will give you an X
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct with 4 conditions 1
not sure what formula to use? IF??? 1
Not sure what formula to use? If?? 1
I can't seem to find anything with regards to this.. sorry 3
x = 1 or a value 5
Formula Help-returning False 3
Solve for a number (x) 2
Adding a column that used X's 2

Top