View Single Post
  #2   Report Post  
Gordon
 
Posts: n/a
Default

"billynolan" wrote in message

I need to calculate the average student grades on student profile
sheets. for example a student might recieve grades A, A, B, B, A -
how do I get excell to display A as the average grade?


In your example the average is not "A", it's either "A-" or "B+"

You need to give your grades a numerical equivalent (in descending order I
would think) and average them that way. You will also need to add to your
table the grades in between, such as "A-" and "B+"

HTH