How many in column

[Guest]

Hi
Try something like this:
=COUNTIF(A2:A2000,"White")

 

[Ralph Smith]

I have a column of colors:

White
Red
Yellow
Yellow
Black
Red
White
Red
Red
Black
Black
Black
White
White
White

Is there a formula for determining how many of each color appear in
the column?

Thanks in advance.

 

[Ralph Smith]

Thank-you. I have two worksheets, "Data" and "Summary" the "Data"
sheet contains all the colors information. I would like to place this
formula in the "Summary" sheet.

How do I modify this formula so that it can show up in the summary
sheet?

Thanks again. I am very new to all this.

 

[Alok]

Just add the name of the sheet

=COUNTIF(Data!A2:A2000,"White")

Alok Joshi

 

[Ralph Smith]

Thanks. Worked great.

Just add the name of the sheet

=COUNTIF(Data!A2:A2000,"White")

Alok Joshi