total colum using x instesd of numbers what is the formula

[Chopper-One]

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

[davesexcel]

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

webdings font
r
will give you an X

[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")
--
Gary''s Student


"Chopper-One" wrote:

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

[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

"Chopper-One" <[email protected]> wrote in message
news:[email protected]...
> Doing a attendence roster. want to use x instead of a number. Don't know
the
> formula. could use some help