Formulas working on one spreadsheet but not on another

Hello all,

I have managed to make a solution work on one spread sheet, but when relaying it into another spread sheet, I am getting errors.

See the attached workbook wherein I have managed to make the formula in cell G10 work.

However when applying to another Excel document the AVERAGEIFS formula returns a DIV/0 error; the formula or function used is dividing by zero or empty cells.

In this new spread sheet, the table array being referenced has no empty cells, cells with N/A or any other errors. However when I run a filter across the headers in the top of the table array, it picks up blanks. There are blank cells beneath the referenced table array, but these are not included in the cells I have referenced in the formula so I don't understand how they could be the cause of this issue.

On the new spread sheet that I have tried to relay the formulas on to, one of the reference cells being used in the AVERAGEIFS formula takes its date from the report date (=ReportDate). Could this be the cause of the problem?

(I can't upload the second spread sheet; it's enormous and includes sensitive information).

Hi than_gold,

The table array in the new spread sheet fulfils all the criteria according to that link you've posted.

If I used IFERROR, wouldn't the formula still essentially just return a blank or whatever you tell it to return when there is an error?

In the new spread sheet table array, I have a column of dates, two columns of text with 'general' formatting, and a column of percentages. The column with percentages in it has some blanks, but that link that you posted says: If a cell in average_range is an empty cell, AVERAGEIF ignores it. So surely these blanks should be fine?