Try this - sets value to 0 if no data

=IFERROR(AVERAGE(IF(Admissions!A3:A$1018=A3,Admissions!B3:B$1018)),0)