I want to be able to average a series of written text grades i.e.
Dist*, Dist, Merit, Pass and Fail from cells that have already been
populated with these grades. I want it to work that if a student gets
a Dist, Merit and a Pass then overall they get a Merit. This sum will
have to average a range of up to 6 different grades starting from if
there is only one grade currently in the range i.e. i have only
written reports for term 1. I am currently doing this in Excel 2003
but do have access to Excel 2007 should this be easier in the more
Hope you can help.