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

[dclayton]

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.

 

[Gary''s Student]

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

 

[Glenn]

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.