Assigning a Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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