All I could get it to do was average 3 weeks grades instead of the 6 weeks I
put in for (from G1:M1) and by highlighting the whole area-I used the
=AVERAGE,etc. I'm not sure what I did wrong still.