total colum using x instesd of numbers what is the formula
 

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

total colum using x instesd of numbers what is the formula
 

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

total colum using x instesd of numbers what is the formula
 

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" wrote in message
...
Doing a attendence roster. want to use x instead of a number. Don't know
the
formula. could use some help

total colum using x instesd of numbers what is the formula
 

Chopper-One Wrote:
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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519183