I have a data entry worksheet called 'Entry', and a worksheet that calculatates totals called 'Total', within a workbook. Using the data in the 'Entry' tab, I want to Average all the items in Column A with the exception of the header and put it into cell A1 on the 'Total' tab. I DO want the Average to calculate any zero's, but I do not want it to consider blanks to be zeros. Please help! Thanks!!