total colum using x instesd of numbers what is the formula

C

Chopper-One

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

Gary''s Student

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
 
Top