View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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