D
dernspiker
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
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