consolidated list of totals

I am looking for a summary of data from certain excel fields so that the totals are arranged in a consolidated list of totals. First, sort/filter the spreadsheet by “Project Name” in Column A. Sort by prefix: CO, GA, HI, MAS, National, NCAL, NW, OH, SCAL, CD, CS, HP, OR, and TPMO. Second, columns H,I,J needs to show totals of how many “Blank” cells are in each of the various prefixes. Such that if a blank cell is eventually populated with data, the totals would automatically reflect fewer blanks cells in the list of totals. Since columns H,I,J have a few cells that are missing information, my job is to track how many "Blanks" or cells there are that will need to be populated. So, over time I will see a reduction in these "Blanks" as information is collected and populated. For example: CO in Column "H" it has 289 blank fields that are missing information. Please see the attached picture. This illustrates the end result I need you to accomplish. This is the format I need the final totals to be in. However, this picture was accomplished manually. So I would like an automated way to display the same information.