Help with function

[psyd]

I am currently summing several cells on different sheets, determining
percentage, assigning a 1 through 5 value based on the percentage, on
seperate sheet I am taking the 1 through 5 values and trying t
determine a percentage for completed fields above 3 and the average o
these values.

I tried =average('sheet 1'$a$1,'sheet 2,etc.) but I'm having troubl
with this. I also need to take the percentage of those above 3 vs al
complete. Any help would be appreciated. :

 

[Alex Delamain]

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