I don't think you need the apostrophes
ie
=average(sheet1!A1, sheet2!A1,etc)

To get your percentage use something like
=if(a1<0.2,1,if(a1<0.4,2,if(a1<0.6,3,if(a1<0.8,4,5 ))))

Finally to get the percentage of cells with 3 or better

=countif(a1:a100,"=3")/count(a1:a100)


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=275546