I am using this formula to average a range but it returns a division by zero error.
AVERAGE(IF('2017'!$B$3:$B$150=A37,'2017'!$D$3:$D$150))) A 37 is a cell reference with text in it.

PLEASE HELP ME FIGURE THIS OUT ANYONE THANKS!!!!