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

Just put the code number in the column for ethnicity.

If you use a different sheet for each month, then the COUNTIF function can
give you the sum by ethnicity.
--
Gary''s Student - gsnu200738


"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

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

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