COUNTIF?

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

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
 
A

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top