=AVERAGE(IF(MOD(COLUMN(O23:AA23)-COLUMN(O23),2)=0,MATCH(O23:AA23,$AH$11:$AH$24,0)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Empy" wrote in message
...
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. :)