Conditionally counting blank cells in a large table by referencing values in the table

Thank you for the suggestion! I have modified my original post to attach a sample sheet, and I also changed all the text to apply to that sample.