ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/141368-formula.html)

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

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

"rehirt@Thompson" wrote:

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