Try this - sets value to 0 if no data
=IFERROR(AVERAGE(IF(Admissions!A3:A$1018=A3,Admissions!B3:B$1018)),0)
Try this - sets value to 0 if no data
=IFERROR(AVERAGE(IF(Admissions!A3:A$1018=A3,Admissions!B3:B$1018)),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks