Trying to Find Values in One Column and Return a Sum of Text Values in Another Column

Hi all. I need some help with some functions to count text values. The situation is I need to look in column A for all of the cells that show "#N/A" (from a VLookup I did), and then look to column E and return a count for each of the text there (i.e. IN, OUT, LEAVE, etc...). My end goal is to create a table that is dynamic so that the counts for each text changes when I change the word in column E. I have attached the relevant columns in the spreadsheet.

Thanks!