I am working with multpile workbooks. (Site 1, Site2..ect). I have a master
workbook that pulls data (Rating numbers from each Site workbook). The master
book compliles and averages all the data. The problem is that if a Site
workbook contains a blank cell it places a zero in the materbook. The zero is
counted and effects the overall average. The critera for rating is 0-10 so I
need to capture the zero but if the cell is blank I need the master cell to
remain Blank. Here is what I have so far.

Site 1 workbook In cell P-22 (=SUMIF(B22:F22,"<""")

Master book formula for retrieving the data In cell E-10 ([Site 1 Manager
Performance Assessment.xls]MPAS'!$P$22

Masterbook formula for rating the value
=IF(COUNTA(E10:E26)=0,"",AVERAGE(E10:E26))

Thanks in advance your time is always appreciated on this end.