Thanks for this, I'm using:

=AVERAGEIF('INPUT SHEET'!F2:F249,"Y",DR2:DR249)

However it is coming up with a #DIV/0! error

Could this be because there are blank cells in both the F and DR columns? and if so is there a way round?

Cheers