Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
Each entry in my database has a category listed in column A. I would like to
create a column that produces the n for each entry's category. For example, if column A reads: blue red red green green green Then column B should read: 1 2 2 3 3 3 Anyone know what formula I can use for this column B? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
=COUNTIF($A:$A,A1)
HTH Otto "AAA1986" wrote in message ... Each entry in my database has a category listed in column A. I would like to create a column that produces the n for each entry's category. For example, if column A reads: blue red red green green green Then column B should read: 1 2 2 3 3 3 Anyone know what formula I can use for this column B? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
Using this formula, how would I enter in my categorical criteria?
"Otto Moehrbach" wrote: =COUNTIF($A:$A,A1) HTH Otto "AAA1986" wrote in message ... Each entry in my database has a category listed in column A. I would like to create a column that produces the n for each entry's category. For example, if column A reads: blue red red green green green Then column B should read: 1 2 2 3 3 3 Anyone know what formula I can use for this column B? Thanks in advance. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
Did you try Otto's formula? Try it, then post back with why it doesn't work
for you. You'll also have to explain what a "categorical criteria" is. Regards, Fred "AAA1986" wrote in message ... Using this formula, how would I enter in my categorical criteria? "Otto Moehrbach" wrote: =COUNTIF($A:$A,A1) HTH Otto "AAA1986" wrote in message ... Each entry in my database has a category listed in column A. I would like to create a column that produces the n for each entry's category. For example, if column A reads: blue red red green green green Then column B should read: 1 2 2 3 3 3 Anyone know what formula I can use for this column B? Thanks in advance. . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
Remind me please what is a 'Categorical criteria'?
Mike "AAA1986" wrote: Using this formula, how would I enter in my categorical criteria? "Otto Moehrbach" wrote: =COUNTIF($A:$A,A1) HTH Otto "AAA1986" wrote in message ... Each entry in my database has a category listed in column A. I would like to create a column that produces the n for each entry's category. For example, if column A reads: blue red red green green green Then column B should read: 1 2 2 3 3 3 Anyone know what formula I can use for this column B? Thanks in advance. . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
When I entered this formula, it did not put out the correct numbers. In the
above example, "categorical criteria" is red, blue, green. And I want the formula for column B to show me the total number of reds, blues, and greens in column A. So for example: If column A looks like this: red blue blue green green green Then column B looks like this: 1 2 2 3 3 3 Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
The formula is correct, so it must be the way you entered it. Copy the
formula, and paste it here, then tell us the steps you went through to put it in your spreadsheet. Finally, saying "it did not put out the correct numbers" doesn't give us much to go on. What numbers did it put out, and why are they incorrect? Regards, Fred "AAA1986" wrote in message ... When I entered this formula, it did not put out the correct numbers. In the above example, "categorical criteria" is red, blue, green. And I want the formula for column B to show me the total number of reds, blues, and greens in column A. So for example: If column A looks like this: red blue blue green green green Then column B looks like this: 1 2 2 3 3 3 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |