Adding in Excel
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
|