Average of cells matching date criteria ignoring DIV/0

Hi there,

I'm working on a dashboard which shows the MTD productivity of staff. Currently, one sheet contains dates and the daily productivity percentage across different aspects of their role. Some percentages return #DIV/0 as the person didnt work in that area that day.

The formula im using at the moment is:

Please Login or Register  to view this content.

This sums the percentages matching the current month (Dashboard!K1) and then divides by the number of percentages, excluding blanks.

Trouble is, there are no blanks... G4:G13 is either a percentage or #DIV/0 error.

So I need to rewrite the formula to exclude the #DIV/0 errors.

Can anyone assist with this?

Originally Posted by jeffreybrown

Why not just try to fix the #DIV/0?

Only thing I could do is amend the formula that calculates the percentages so that if it equals an error to simply display a blank cell I guess? Any idea how I can do that? I should probably post seperately...