Applying INDIRECT within this AVERAGEIFS formula

Hi

I have attached a file which has an AVERAGEIF formula in Rating!C3:C7
I would like to incorporate the INDIRECT function so that cells Rating!C1 and D1 set the range for the calculation. In this example I want to search between New Design Row 3 and Row 7 inclusive ONLY.

My attempt in Rating!D3 returns#REF

Where have I gone wrong?
Any help as always would be much appreciated