Thread: Adding in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] lilguycast@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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