I am calculating an average for a teams quality assurance numbers. They are
not all audited on each item every week. But all items are included on the
worksheets.

I have about 10 worksheets I need to draw averages from and have them
calculate on a "TOTALS" worksheet. These worksheets have "updated" info on
them once a week. Sometimes the data is blank or "0". How can I get an
average without the blanks and/or zeros counting against the team member when
certain items weren't audited?

Thans for your help in advanced.

Dana