Hi,

Let's say you want to cout specific numbers in a column and knoe how many
time they repited Try as below:

=COUNTIF(A1:A100,4)

assumen your numbers are in the range A1:A100 and this formula return the
number that the number 4 has repited in your range.

Thanks,
--
Farhad Hodjat


" wrote:

I deal with a lot of data input into Excel spreadsheets. I have
evaluation data that rates subjects in a 1-5 scale, and I need to
tally up all the people's answers and average them out for each
subject. Which means I need to input 30+ individual answers. I was
wondering if its possible to add value to a cell by clicking on it,
and each time I click the cell it adds 1 value. Example: one person
rates program a 4, so i click the cell that represents a 4. Next
person rates it a 4 as well, so i'd click the cell and it
automatically adds one, so totalling two 4 ratings. Is this possible?


Thx