COUNTIF?

  • Thread starter Thread starter AAA1986
  • Start date Start date
A

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