Thread: I want to get and A to count as a 1 in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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.
Reply With QuoteReply With Quote