AVERAGEIFS function not working in some of the data sheets

[mostafa.elnazer]

Hey, my Friends ...

I have a strange case in my attached data files ...

I have different daily data files for meteorology, and I'm applying the AVERAGEIFS function on them, but I have only results for the file (Sues_gulf_over_water_Daily_19820101) in one of its sheets but not all the other sheets ...

Then I have tried the same function on the other file and it fails completely in all the sheets of it ...

I have checked the cell formates for both files and adjusted the date cells to date format and the data columns to a number format after getting the #DIV/0 error but this didn't fix the error ...

I have no other clue for this case ...

can anybody help?

Thanks ...