Formula

[rehirt@Thompson]

I have a column of numbers, 1-5.
Each number represents ethnicity of a student.
I need a count of all the 1 that appear in a column and the answer put into
a specific cell. I would then do the same for 2-5. Each of these totals would
be in a cell across from their ethnicity name. How do I write the formula to
find and count just a specific number in a column? Thanks!
Eric Hirtriter
Teacher
Spring ISD
(e-mail address removed)

 

[FSt1]

hi,
countif.
say all your data is in column A2:A100.
=countif(A2:A500,1)
A2:A100 is the search range and 1 is the criteria.
do the same for each number 2-5.

regards
FSt1