hey ya'll how do i auto sum a cell using the letter x instaed of .

[Guest]

hey ya'll how do i auto sum a colum using the letter x instead of using a
number

 

[Gord Dibben]

To count number of "x"es

=COUNTIF(A1:A100,"x")

Gord Dibben Excel MVP

 

[Don Guillett]

Gord answered but I couldn't resist asking what the sum of x and x is?
Sinister Rod Serling music here.