I'm working on GPA. Due to the help on 'mrexcel.com' I have managed to
starts up an average that translates my Alpha grades into a GPA.

But then a roackblock came.

You see, my columns are set up as |CLASS|ABSENCES|CLASS|ABSENCES| and so
forth. So when there has been data entered into the Absences column, it
disrupts the averaging of the grades.

So what I need is some way to incorporate a code for skipping cells with my
equation:

=IF(COUNTA(O23:AA23),SUM(AVERAGE(OFFSET($AH$11,MAT CH(O23:AA23,$AH$11:$AH$24,0)-1,1))),"")

So that it only averages cells O23,Q23,S23,U23,W23,Y23,AA23 (which are the
letter grades that are being Matched to decimals).

I decided to post this question here after seeing another thread
(http://www.microsoft.com.nsatc.net/c...&cr=&sloc=&p=1)
that seems very similar to what I need, but I just can't seem to put them
together.

Any help is appreciated. :)