Using average on Named Range in SUMPRODUCT

Hello,

I have a sample SUMPRODUCT formula partially working. What is not working is the average() embedded. While it does return a numeric value, it is way off the mark, and I cannot seem to find out where the problem is.

Please see the attached file.

The problem is in "Overall Reporting", Col F, F1. If you see the formula, I put an Average() on the named range. The p2 and p3 rows do seem to return the right value, but not p 1 row for site A. I'm pretty sure I am just using ONE named range.

The 30.6 doesn't make sense.

Thank you