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

jrod98 · Oct 25, 2004

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

Gord Dibben · Oct 25, 2004

To count number of "x"es

=COUNTIF(A1:A100,"x")

Gord Dibben Excel MVP

Don Guillett · Oct 25, 2004

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

Removing letters from cells	2	Sep 17, 2013
Copy Sheet #'s, but leave cell reference	3	Nov 9, 2009
How do I post date a letter?	1	Jan 12, 2017
Controlling Cells included in a sum command	3	Dec 14, 2012
Global Template Network and saving auto texts & macros	2	Jun 6, 2017
Auto Sum issue	2	Dec 9, 2008
sum totals in excel	4	Jun 6, 2009
The sum of the same function that is used for a range of cells	2	Sep 24, 2013

Ask a Question