Working out average after checking another column

[Cmorgan]

Afternoon,

I have been using this formula to work out the average in the column DR:

=AVERAGE('INPUT SHEET'!DR2:DR249)

However, I now need to only work out the average in column DR for those cells that have Y in the corresponding cell in column F.

I appreciate any guidance that you can give.