COUNTIF?

[AAA1986]

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.

 

[Otto Moehrbach]

=COUNTIF($A:$A,A1)
HTH Otto

 

[AAA1986]

Using this formula, how would I enter in my categorical criteria?

 

[Fred Smith]

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

 

[Mike H]

Remind me please what is a 'Categorical criteria'?

Mike

 

[AAA1986]

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

 

[Fred Smith]

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