| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
