Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rehirt@Thompson rehirt@Thompson is offline
external usenet poster
 
Posts: 1
Default Formula

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