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.

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.

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.

.

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.

.

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.

.

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

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