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.
.
|