Good question.

Let's say column A, rows 1 thru 20, contain:

Caucasian
Caucasian
Caucasian
Caucasian
Caucasian
Caucasian
Caucasian
Caucasian
Caucasian
African American
African American
African American
African American
African American
Caucasian
Caucasian
African American
Caucasian
Caucasian
African American

then

=COUNTIF(A:A,"Caucasian") will display 20
and
=COUNTIF(A:A,"African American") will display 7
--
Gary''s Student - gsnu200738


"KaraSuzanne" wrote:

So tell me how that works if I have one column for Race and I enter Caucasian
in a field, for example and then African American underneath it in the same
column. How can I set it up to tell me how many times Caucasian was entered
for example?

Thanks!
--
Kara


"KaraSuzanne" wrote:

I am working on a spreadsheet that has demographic data. I would like to be
able to assign a value to each race (i.e. African American=1, Caucasian=2,
Hispanic=3, etc.). Is there anyway that I can do this within an Excel
spreadsheet?

I would need to be able to have the program summarize the column of such
demographic information so that it could tell me how many people of each race
participated in our program for the month.

Thanks!

--
Kara