I want to get and A to count as a 1 in Excel
 

i am using excel 2000 and i am useing 35 times 35 cells. everything is just
going to be a one or a zero, but I really need to be able to just type an A
and that count exactly the same as a one would, but I can't type all A's. If
anyone could help I would appreciate it.

I want to get and A to count as a 1 in Excel
 

say we want to the number of A's in A1 thru Z100
=COUNTIF(A1:Z100,"A")

--
Gary''s Student - gsnu200820


"dclayton" wrote:

i am using excel 2000 and i am useing 35 times 35 cells. everything is just
going to be a one or a zero, but I really need to be able to just type an A
and that count exactly the same as a one would, but I can't type all A's. If
anyone could help I would appreciate it.

I want to get and A to count as a 1 in Excel
 

dclayton wrote:
i am using excel 2000 and i am useing 35 times 35 cells. everything is just
going to be a one or a zero, but I really need to be able to just type an A
and that count exactly the same as a one would, but I can't type all A's. If
anyone could help I would appreciate it.

Feels like I just typed this a few minutes ago...

You can make the number 1 display as the letter A. Use this as a custom number
format:

[=1]"A";0

Then you can just SUM() the range to get a total.